Query not completed Project Initiative with all underlying epics are closed

[Sanket Salvi]

My issue Hierarchy is Project Initiative - Epic - Story. I am looking for a query which finds all Project Initiatives which are not in " Completed" status.l but all the underlying Epics are in "Closed" status. I currently have the query which finds Project Initiatives which are not in "completed" status and has atleast one Epic in "closed" status. 

Project= ABC and issuetype = Project Initiative and Status not in (Cancelled, Complete) and issuefunction in PortfolioParentsof ("issuetype=Epic and status =Closed")

[Karan Sachdev]

Hey Sanket,

We don't have a way to achieve this via native JQL search. You may have to explore the marketplace apps to see if they offer such extended JQL functionalities.

Alternatively, you can use automation rule to send a reminder to close the Initiative when all epics are closed.

This approach is described in another community post here: https://community.atlassian.com/forums/Jira-questions/Re-Get-list-of-Epics-where-there-are-No-Open-child-issues/qaq-p/2764951/comment-id/1036905#M1036905

Thanks!

[Karan Sachdev]

Here are the screenshots of the rule from my site. We're sending a reminder mail if the parent issue is not in the status category Done, and all child issues are in the status category Done.