JQL - Show Epics That All Task Underneath That Epic Are Marked As Done

[Harvey Bennett]

Looking for what the title states. Is there a way to write JQL to show epics that if they have task underneath them and all the task underneath this epic are marked with a resolution that is != unresolved? I have Scriptrunner and JQL-tricks since I'm sure one or both of those might be needed to make something like this accessible. 

[Merle Fischer · Accepted solution]

hey @Harvey Bennett ,

funny that question popped up yesterday and has solutions for you ;): https://community.atlassian.com/t5/Jira-questions/How-to-get-Epics-where-all-Stories-are-done/qaq-p/1030332#M330200

solutions was based on this thread from 2013:https://community.atlassian.com/t5/Jira-questions/Filter-all-Epics-that-are-incomplete-but-only-have-Stories-that/qaq-p/233701

Cheers

Merle

[Harvey Bennett]

Oh well that was easy! Thanks for the help and guidance.

[Merle Fischer]

Happy to help :)

[Jessica Malenfant]

Do you know if can be done using JQL alone without any add-ons?

[Harvey Bennett]

I am honestly not sure. I listed those plugins because what I was asking for if it was doable in pure JQL might be hard to put together and not worth the hassle. The plugins keep the JQL 'cleaner' IMO. My best guess is something along the lines of creating a filter that check for my epic non resolved criteria and calling it another JQL filter that uses a "parent" function might work as well. BUT I not even sure if there is an out the box function that checks for children or the parent that reads from another filter.