JQL where ALL sub-tasks meet criteria

Mathew Lederman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2023

I am trying to find parents in an To Do or In Progress statusCategory where ALL sub-tasks are in a Done statusCategory. 

Here's what I've tried so far:

project = RQM and statusCategory != Done and issue in parentsOf("Project = RQM and issuetype = Sub-task and statusCategory not in ('To Do','In Progress')")
project = RQM and statusCategory != Done and issue in parentsOf("Project = RQM and issuetype = Sub-task and statusCategory = 'Done'")

Unfortunately both return results where at least of the sub-tasks meet the criteria, but I need to find where ALL of the sub-tasks meet the criteria. 

Any suggestions would be appreciated. 

1 answer

1 accepted

0 votes
Answer accepted
Laurie Sciutti
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2023

Hi @Mathew Lederman ~ try this:

 

project = RQM and statusCategory != Done and issueFunction in hasSubtasks() and not issueFunction in parentsOf("project = RQM and statusCategory != Done")
Mathew Lederman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 14, 2023

Perfect that worked! 

Like Laurie Sciutti likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.20.27
TAGS
AUG Leaders

Atlassian Community Events