How to find all open tasks where all subtasks are closed

Sonya Sevova December 3, 2013

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?

2 answers

0 votes
Lisa Forstberg October 28, 2015

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")

0 votes
Chris Hodgens December 4, 2013

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")

Suggest an answer

Log in or Sign up to answer