Jira: Filter output as JQL-parameter without add-ons

Samuli Miettinen

Is it possible to use native JQL-functionality to search utilizing the search results of another query?

For example:

• Query A: issuetype = Epic AND priority in (1,2,3)

  • Filter ID: 12000

• Query B: issuetype = Story AND "Epic link" in (filter = 12000)

Note: Company policy restricts add-on usage, that's why I'm looking for a JQL-native solution.

Bill Sheboy

Hi @Samuli Miettinen -- Welcome to the Atlassian Community!

The short answer is: no, that is not possible.

Longer answer:

JQL is not a generic SQL, and so does not support syntax like that.  Your possible work-arounds depend upon how often you need to do this, your desired level of effort, and willingness to purchase addons.

You have already noted a restriction on purchasing addons for JQL, so we can skip that option.

If you need this search ability infrequently, you could perform multiple queries, export the results to a spreadsheet, and perform the additional matching in the spreadsheet.

Kind regards,
Bill