We have a bunch of parent tickets, each of which may have several subtasks. One of those subtasks should be - for example - a user testing subtask, flagged with a label like "UserTesting". I am struggling to come up with a query using Jira + ScriptRunner that finds all parent tickets that are missing a subtask with that specific label. I can come up with queries that show parents of subtasks where the subtask HAS a specific label, but I cannot figure out how to show the parents that are MISSING a subtask with a particular label. Any ideas on how to do this?
Does this do what you want?
issueFunction not in parentsOf("issuetype = Sub-task AND labels IN(NFT)")
That returns issues that are not parents of Sub-tasks with a particular label. You'd want to refine it more, like maybe:
issueFunction not in parentsOf("issuetype = Sub-task AND labels IN(NFT)") AND issueFunction in hasSubtasks() AND issuetype = Story
Which is "stories that have sub-tasks, but no sub-tasks with the desired label".
As a side note, you may want to think about the use case here - labels may or may not be the cleanest way to do whatever you are doing.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events