Find Parent Status

[Nicolas Mayans]

Hello community! I hope they are doing very well! They are asking me for a search where they need to know the status of the parent. The query I try to do it with is this "project = EPC AND status = Done AND issuetype = Epic AND parent is not EMPTY" and then I can't find a way. I checked the JQL documentation but I wouldn't be finding what I'm looking for. Thank you so much!

[Trudy Claspill]

Hello @Nicolas Mayans 

Do I understand correctly that you are trying to get the list of the parent issues for the issues found by your query? Your query will return Epic issues in the EPC project where the Epic status is Done and the Epic has a parent issue.

With native Jira filtering capabilities you cannot get the list of parent issues based on a query that gets you a list of child issues. You would need a third party app that extends the searching capabilities of Jira. Are you willing to consider a third party app?

[Charlotte Santos -Appfire-]

Hi @Nicolas Mayans

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all parents of epics in project EPC:

issue in parentsOfIssuesInQuery("project='EPC' and type=Epic")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!