Open Parents with ALL Sub-tasks Closed JQL?

Question

How do I JQL Parent tickets that have ALL Sub-tasks that are closed?

Can't figure this one out!

1) Parents with resolution = Unresolved

and

2) ALL of their Sub-tasks with resolution != Unresolved

Probably requires an addon.

We have both ScriptRunner Enhanced Search and JQL Search Extensions addons.

Thanks

Tamás Fésüs_k8968c · Answer

In Scriprunner Enchanced Search this works for me:

issuetype not in (subtaskIssueTypes(), Epic) and status not in ('Done', 'Closed') and numberOfSubtasks >= 1 and NOT issuefunction in parentsOf("status not in (Done, Closed)")

Nick Pead · Answer

@ian.johnsen Did you find a solution?  I'm looking for the same filter.

Thanks

ian.johnsen · Answer

So for more context. We have a ton of Parent tickets that are open and all ALL of the subtasks are Done. We need to find all of these so we can close them.

The filter needs to show:

* Only Parent tickets

* Only Open Parents (StatusCategory != Done works, but would prefer using Resolution = Unresolved)

* ALL subtasks are Done (StatusCategory = Done works, but would prefer using Resolution != Unresolved)

What we don’t want the filter to show:

* Parents with any Open subtasks.

* Sub-Tasks

* Closed Parents

I have been messing around with this for hours and cant figure it out!

Thanks!