JQL to find parents that are missing a subtask with a specific label?

[Daniel Becker]

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?

[John Price · Accepted solution]

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.

[Daniel Becker]

Thank you! This does get what I was looking for.