Unresolved Epics with Done Issues (Story/Task/etc.)

[Rachel Pike]

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

[Hannes Obweger - JXL for Jira]

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:

• Create a so-called "sheet" in JXL with a JQL that includes a.) all unresolved epics, and b.) any possible child issues that are not done. Don't worry about the parent/child relationships; JXL will sort this out for you.
• In your JXL sheet, enable the default issue hierarchy. This is a one-click operation.
• In your JXL sheet, filter out all "empty" epics, i.e. all epics that don't have children in the current result set. That's again a one-click operation.

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