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"))
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs