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