JQL where ALL sub-tasks meet criteria

[Mathew Lederman]

I am trying to find parents in an To Do or In Progress statusCategory where ALL sub-tasks are in a Done statusCategory. 

Here's what I've tried so far:

project = RQM and statusCategory != Done and issue in parentsOf("Project = RQM and issuetype = Sub-task and statusCategory not in ('To Do','In Progress')")

project = RQM and statusCategory != Done and issue in parentsOf("Project = RQM and issuetype = Sub-task and statusCategory = 'Done'")

Unfortunately both return results where at least of the sub-tasks meet the criteria, but I need to find where ALL of the sub-tasks meet the criteria. 

Any suggestions would be appreciated. 

[Laurie Sciutti · Accepted solution]

Hi @Mathew Lederman ~ try this:

project = RQM and statusCategory != Done and issueFunction in hasSubtasks() and not issueFunction in parentsOf("project = RQM and statusCategory != Done")

[Mathew Lederman]

Perfect that worked!