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

Saskia Veldhoen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 30, 2024

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")

1 answer

1 accepted

3 votes
Answer accepted
Rudy Holtkamp
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 30, 2024

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 30, 2024

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

Like Rudy Holtkamp likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events