Looking for JQL to find stories where subtasks named certain ways are missing

Question

My end result is that I'm trying to keep an eye on many teams activities, beginning with ensuring that they are creating and using Code Review tasks.

I'm looking to create a dashboard that only shows me stories and assignees where the story is missing a task with a certain name in the current sprint.

So I've been able to get all of the stories in a given sprint with

issuetype = story and sprint in opensprints()

Now I'm trying to figure out how to use JQL to eliminate stories that have a child task with the words "Code Review". These tasks are pretty easy to find with

issuetype = "Technical Task" and sprint in opensprints() and summary ~ "Code Review"

so I need the intersection of the two above queries, and I'm having a difficult time finding it - I think the issue in/not in linkedIssuesFromQuery("JQL query") plugin might help and I"ve installed it, but so far, I haven't found the solution.

If anyone has addressed this problem in the past or something similar to it, I would be grateful to hear what your solutions are.

Thanks!

Udo Brand · Answer

Hi Brian,

in addition to what Daryl said you could use jql function from script runner. Depending on your setup you could use parentsof(subquery) or linkedissueof(subquery, linkname) like

issuetype = story and sprint in opensprints() and not issuefunction in parentsof("filter = filter2")

where filter2 is your saved second filter.

darylchuah · Answer

Hi Brian

Alternaltively you can try using JQL Tricks Plugin which offer a bunch of additional subtask query functionality, http://www.j-tricks.com/jqlt-subtask-functions.html