Find parents where ALL sub-tasks meet a condition

[stringsonfire]

How can I find parent issues where ALL of their sub-tasks meet a condition (not just "at least one")?

We have ScriptRunner, and I've been looking at the Subtasks issue functions, but so far I haven't figured this out. There's an example for "at least one open subtask", but there is not an equivalent for something like "all subtasks are open".

[Tansu Akdeniz · Accepted solution]

Hi @stringsonfire 

You can use the following query according to your needs:

• issueFunction in parentsOf("WRITE_SUBTASK_QUERY")

Ex; it returns parent issues where there are sub-tasks resolved. 

• issueFunction in parentsOf("resolution is not EMPTY")

EDIT - it returns parent issues where all sub-tasks are resolved. 

• issuefunction in parentsOf("type in subtaskIssueTypes()") and not issuefunction in parentsOf("resolution is EMPTY")

Regards.

[stringsonfire]

That works for parents that have at least one subtask matching the condition, but it does not only show parents where ALL subtasks of the parent match the condition.

[Tansu Akdeniz]

Got it. It should definitely work.

issuefunction in parentsOf("type in subtaskIssueTypes()") and not issuefunction in parentsOf("resolution is EMPTY")

[stringsonfire]

Thanks, it's quite a bit more fiddly to set up with complex conditions vs some kind of "parentsOfOnly()" function, but as I don't think that exists this will definitely get me the query results I'm after

[stringsonfire]

Do you want to edit your answer so that I can accept it?

[Tansu Akdeniz]

I edited my answer.