Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,488
Community Members
 
Community Events
165
Community Groups

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

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

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you