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

1 vote
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

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,313 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot