JQL to find Epics that are done, with incomplete child issues

[Kimmo Kyle]

Find all Epic issue types

Which are set to a "Done" resolved state

But which have child issues which are not in a "Done" resolved state

How might I do this with JQL?

[Muhammad Ramzan_Atlassian Certified Master_ · Accepted solution]

Welcome to the community, you can achieve the required functionality by using a third party plugin, famous one's are 

• JQL Search Extensions for Jira & reports
• Script Runner 

below is the example of JQL Search Extensions for Jira & reports

find all epics with status=done where child's status is not equal to done

issue in epicOf("status!=done") and status=done

[Maximilian Weißböck]

Can not be done with JQL alone, but with Script Runner for Jira there are JQL Extension for this kind of stuff, eg:

-- All Issues from BABE withe done Epic but Issue is not done

issueFunction in issuesInEpics("project = BABE and resolution is not EMPTY") and resolution is EMPTY

[Kimmo Kyle]

Thanks. We don't have ScriptRunner I'm afraid..

[Olga Videc]

Hello Kimmo,

What Maximilian wrote is correct, this is not possible by default in JQL.

You need ScriptRunner or some other plugin(there a few others).

BR, Olga

[Tomáš Vrabec]

Sidenote: I would also suggest to protect your Epic workflow in two ways:

1. You are not able to close the Epic when any child is unresolved
2. Close and Resolve all childs, when closing Epic

[Kimmo Kyle]

@Tomáš Vrabec Thanks - how is this configured in the Epic workflow?

[Tomáš Vrabec]

@Kimmo Kyle I am using JMWE application for that. 

[Kimmo Kyle]

Ah - so the Jira workflow schemes don't natively support such rules? It can only be done with a 3rd party app?

[Tomáš Vrabec]

@Kimmo Kyle native Jira doesn't have much advanced rules. I do suggest both JMWE or Script Runner as very basics applications to achieve anything. There are tons in feature request in Atlassian backlog, but its like 10 years "Gathering interest". Those app will do it and will do it now.