A JQL filter that will show me open Epics with all of there Sub-task complete

[Zachary Sharpe]

What i would like is a filter or JQL search or even a JQL for structure that allows me to see all Epics for my project that child tickets/sub-task that are complete. With the Epic still open. The end goal is to have filter that provides backup to the user. So when all child tickets of epics are complete i can take the epic to a ready to test state or closed. 

[Laurie Sciutti · Accepted solution]

Hi @Zachary Sharpe ~ the straight JQL (if you have ScriptRunner) would look something like this (I included Stories and Tasks since I'm guessing you would want to see all issues in an Epic and not just sub-tasks):

statusCategory != Done and issueFunction in epicsOf("project = XXX and issuetype in (Story,Task, Sub-task)") and not issueFunction in epicsOf("project = XXX and issuetype in (Story,Task, Sub-task) AND resolution = unresolved")

[Zachary Sharpe]

@Laurie Sciutti Thank you so much for the help and sorry for taking so long to get back to you. this is exactly what we needed. it helped many members of my team to stream line their work. I can't thank you enough for this filter!!!!!

Thank you, 

Zach

[Laurie Sciutti]

Excellent! I'm so happy this helped you, @Zachary Sharpe !

[Mikael Sandberg]

Hi @Zachary Sharpe,

Welcome to Atlassian Community!

In order to do a nested search you need an app that extends JQL. I have used both JQL Tricks and Scriptrunner to similar searches, but there are other apps in the Marketplace that can do this as well. 

[Mikael Sandberg]

You can also use automation to change the status of the epic when all child issues are done. Here is an example from the Automation library that you can use as a starting point:

[Danut M _StonikByte_]

Hi @Zachary Sharpe,

Building such JQL could be difficult. Instead, you could try using the Work Breakdown Structure (WBS) gadget offered by our Great Gadgets plugin.

This gadget takes the issues from a specified filter and displays them in a tree structure, by their hierarchy, in form of Epics > Stories, Tasks > Sub-tasks along with their status.

All you have to do it to have a filter that returns the issues to be grouped and to configure the gadget to use this filter. You could use a filter that returns all the issues from your project or version.    

Please note that this app offers many other gadgets that you will find useful. Just have a look over the articles from our blog to make an idea. It can be a great asset for your team and company.

I hope this helps. 

Thank you,

Danut