JQL to filter the parent task with status=Open with its child sub-tasks status are closed

mesinec minecc

I would like to know the JQL with parent task with status=Open (To Do) while its linked child ALL sub-tasks status are closed (Approved). 

The scheme is - 

Task (parent level)

Linked sub-tasks

- Sub-task 1 = Approved

- Sub-task 2 = Approved

- etc.. 

I have searched with this JQL, but it still gave me one or more of child sub-tasks are approved instead of the ALL sub-tasks are approved which I want. 

project = project-name AND issueFunction in parentsOf("issuetype in subtaskissuetypes() and status = approved") 

 

Trudy P Claspill

Try this:

 

project = project-name AND issueFunction in parentsOf("issuetype in subtaskissuetypes() and status = approved") AND issueFunction not in parentsOf("issuetype in subtaskissuetypes() and status != approved") 

The new clause will look for parent issue that have subtasks that are not Approved, and ensure that such issues are excluded from your results.