Hi all. I want to find epics where the epics is still open, but the child issues of the epic are all resolved (done, complete, cancelled, etc.) I want to return the results for epics.
I have JQL Extended Search, not Scriptrunner.
I tried the query below in JQL Extended Search, but my results are returning the child issues instead of the epic. Additionally, the results are for any child issue that is done. I only want epics where all of its child issues are statuscategory = done.
Thoughts?
project in (X,Y,Z) and statusCategory = Done AND issue in childrenOfIssuesInQuery("type = epic and statusCategory != Done")
Hi @Rachel Pike
I'm not an expert in the various JQL extensions - but you should be able to solve this with one of the Marketplace's more hierarchy-focused apps.
As an example, this is how it would work with the app that my team is working on, JXL for Jira:
The remaining list of epics should be what you're looking for.
If needed, you could now "mark" these epics e.g. using a label (in JXL, you can bulk-edit issues very conveniently using copy/paste), or export your list to CSV or Excel.
Hope this is useful,
Best,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.