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 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"))
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG