Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JIRA JQL - Find all subtasks that are open where the parent is closed

Tags:

jira

jql

I have to do a little sub-task clean-up and wondering if there is an easier solution to do this using JQL.

Basically i want to find all sub-tasks that are not closed where the parent of that sub-task is closed. Is this possible?

I have tried to google the problem but the majority of the solutions require installation of a plugin which unfortunately i am not able to. Is there an alternative?

My attempt so far:

(project = MYPROJECT        
         AND issuetype = Sub-task 
         AND status in (Open, "In Progress", Reopened, Resolved)
         AND issue in parent(project in ("MYPROJECT")  and status = Closed)
        )

But there is no parent function.

like image 797
ziggy Avatar asked Sep 02 '13 17:09

ziggy


1 Answers

It's not possible with JQL out of the box. But there's a free plugin that allows this. See examples listed here.

The JQL you're looking for should be like this:

type = sub-task and status = Open and issueFunction in subtasksOf("status = closed")

like image 151
grdl Avatar answered Sep 20 '22 06:09

grdl