nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Open Parent Issues with All Subtasks Closed

Ryan Murphy

I'm looking for the best JQL query to provide a list of all open standard issues where every subtask has been closed. I've been using Script Runner to come up with some pretty great queries but I can't seem to get it to work in this instance.

The closest that I can get is the following query but it doesn't seem to check whether every subtask is in the closed stauts, apparently just one of the subtasks:

project = PROJECT AND issuetype in standardIssueTypes() AND status != Closed and issueFunction in parentsOf("project = PROJECT and status = Closed")

Can anyone help me refine this query or use another one that accomplishes what I need?

Accepted answers

Hi Ryan,

I don t have enough subtasks in our tickets to test it properly, but I edited Vijays statement a little bit: as you get issues where subtasks are both open and closed, I made one subquery to a "not in status != closed". Hopefully that works...

project = PROJECT and issuefunction in parentsOf("issuefunction in subtasksOf(\"issuefunction not in parentsOf('type in subTaskIssueTypes() and status != closed') and status != closed and type in standardIssueTypes()\") and status = closed")

All comments

Vijay Khacharia

This was challenging

Here is the JQL.

issuefunction in parentsOf("issueFunction in subtasksOf(\"issuefunction in parentsOf('project= PROJECT and type in subTaskIssueTypes() and status = closed') and status != closed and type in standardIssueTypes()\") and status != closed")

Hope this works for you.

Vijay.

Ryan Murphy

Hi Vijay,

Thansk for your prompt response. I tried the query but it seems to not respond with open parent tickets with all subtasks closed. I see open tickets with only a few, but not all, subtasks closed. Any other ideas?

Vijay Khacharia

Hi Ryan,

I gave a thought again and found an easier solution. Find all the tasks that are open, exclude all the tasks that has open subtasks.

Here is the JQL

project = PROJECT and type in standardIssueTypes() and status != closed and not (issueFunction in parentsOf("project = PROJECT and type in subtaskIssueTypes() and status != closed"))

Vijay Khacharia

The problem here is it returns a task even if doesnt have any sub tasks.

Hi Ryan,

project = PROJECT and issuefunction in parentsOf("issuefunction in subtasksOf(\"issuefunction not in parentsOf('type in subTaskIssueTypes() and status != closed') and status != closed and type in standardIssueTypes()\") and status = closed")

Ryan Murphy

This one seems to work. I was able to return all open tickets where all the subtasks are closed. It also seems to ignore any open tickets with no subtasks. Great job to both Jochen and Vijay! Thank you so much.

Ankit Mathur

Hey Jochen/Vijay,

This query really helped me a lot!

Is it possible (I am guessing no) to have a query that will return all parent tasks with their subtasks closed, however disregard the status for a subtask with the summary "Project Management".

So if Task A has 3 subtasks, out of which 2 are closed

1)Project Management (open)
2)Subtask 2 (closed)
3)Subtask 3 (closed)

It will return Task A as one of the results.

Nithya Ananda_lw391m

Bingo! Thanks alot!

Patricia Bermejo

I would like to obtain a similar query but to obtain the subtaks in open status but the issue parent with closed status. is this possible?

Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira