JQL to find all sub-tasks that are "pending/not done" but their parent is Done/resolved

Ayush Ghuliani
Contributor
October 11, 2023

Is there a way in Jira cloud to extract the above info without using issue function subtaskof and parentof. I am unable to use these since I don't have script runner licence.

 

 

1 answer

1 accepted

0 votes
Answer accepted
Charlotte Santos -Appfire-
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.
October 11, 2023

Hi @Ayush Ghuliani

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all the sub-tasks that are not done but their parents are: 

issue in subtasksOfParentsInQuery("status = done") AND status != Done 

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte

Ayush Ghuliani
Contributor
October 11, 2023

alright. thanks a lot 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events