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

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.


2 answers

This widget could not be displayed.
Daryl Chuah Atlassian Team Dec 19, 2013

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

This widget could not be displayed.

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.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

215 views 3 0
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you