How to find all open tasks where all subtasks are closed

[Sonya Sevova]

Hi all,

I want to find all Open tasks (epics, stories, etc.) where all subtasks are Closed.

The problem is that "issueFunction in parentsOf()" gets back all tasks that have at least one closed subtask but not all subtasks are closed.

Does anybody have an idea how to do that?

[Lisa Forstberg]

hi there, 

I was able to catch the parent of ALL closed subtasks with this addition to my JQL:

AND not issueFunction in parentsOf("project = xxx AND resolution is EMPTY")

but strangely enough it didnt work with

AND not issueFunction in parentsOf("project = xxx AND status = Closed")

[Chris Hodgens]

There may be a simpler way of doing it, but this should work :

issue in parentIssuesFromQuery("issue in subtaskIssuesFromQuery('status = open AND issueFunction in hasSubtasks()') and status = Closed")