Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Rachel Pike
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!
May 26, 2022

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

1 answer

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
May 26, 2022

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.

unresolved-epics-with-all-issues-done.gif

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

Suggest an answer

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

Atlassian Community Events