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

[Ayush Ghuliani]

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.

[Charlotte Santos · Accepted solution]

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]

alright. thanks a lot