Possible to use the result of a filter in a jql?

[Saskia Veldhoen]

I want to see a list of all stories and bugs belonging to a parent (query a), where the parent has a certain value as property (query b).

I started with making a filter to get all the issue keys of the epics (query b) and used this list of keys in my query a.

Query a: project = xxx and (type IN (Bug, Story) and status in (Done) and resolved >= "2024-01-01" AND resolved <= "2024-12-31") and parent in (comma seperated list of results of query b)

Query b: type = Epic and "Categorie" = "yyy"

Is it possible to join both queries, so that I will have only 1 query?

Something like:

project = xxx and (type IN (Bug, Story) and status in (Done) and resolved >= "2024-01-01" AND resolved <= "2024-12-31") and parent in (type = Epic and "Categorie" = "yyy")

[Rudy Holtkamp · Accepted solution]

hi @Saskia Veldhoen & welcome to the community!

Sorry to bring it to you, but with out-of-the-box Jira you can not use a sub-filter/sub-query.

You need to use an app for that, as an example JQL search queries for Jira. But this is probably not the only app which can do this.

[Saskia Veldhoen]

Thank you for the welcome and the response, Rudy. I will take a look at it.