Query for issues where linked issues are not released?

[Deleted user]

So what I want is something like.

Return all issues where the linked issue is not part of a released version.

Somehow I am guessing that I need a plugin like script runner to do this :-(

[Thomas Schlegel · Accepted solution]

Hi Timothy,

you are guessing right. This is not possible with plain Jira, because Jira does not know something like a subquery. 

With scriptrunner you could query like that:

... and issueFunction in linkedIssuesOf("fixversion in (unreleasedversions())")

[Deleted user]

sigh...

Crazy that we need to purchase a plugin for this based on our user count. 

I guess we will get around it some other way.

[Marci Boecking]

Did you ever get this working, Timothy?  I need to query something very similar (display issues that are linked to another project's ticket for which the assigned version of THAT ticket HAS been released).  Otherwise we have to look at these tickets individually....very tedious.

[Lime Trees]

Hi,

you can have a look at Ultimate Guide for our add-on Link Finder. You will find there how to use various functions, one of them which may help you to resolve your problem is linkFinder eg.

issue in linkFinder("fixVersion = unreleasedVersions()")

Regards,

Lime Trees Support Team

[Alexey Matveev]

Have a look at 

unreleasedVersions(project) JQL function

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html#Advancedsearching-functionsreference-unreleasedVersionsunreleasedVersions()