You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Join now to unlock these features and more
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.
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")
@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!!!!!
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:
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.