Is there a way I can run a query to see what open sub-tasks there are against closed parent tickets?

[angela_williams]

Is there a way I can run a query to see what open sub-tasks there are against closed parent tickets?

I have stories that are pretty old, which still have open sub-tasks on, I would like to clear these up and have created a query to see sub-tasks against the parent, but now I want to know if the parent has been completed in order to close those sub-tasks too.

[Marc - Devoteam]

Hi @angela_williams 

Not ootb you will need a 3rd party app that will extend the JQL options in Jira.

You could look at:

• JQL Search Extensions
• JQL Tricks

[Faizan Sayyed]

Hi @angela_williams 

Thanks for reaching out to the community.

In addition to 3rd party add-on, as a workaround, you can achieve the use case by performing the below steps

• Run this query first on the specified project and export the results to get the issue key of all the stories.
  
  

project = "XXX" AND issuetype = Story AND status = Done

• Once done we can then run the below JQL
  
  

(issuetype = Sub-task AND status NOT IN (Done)) AND parent IN (Issue keys fetched from the export separated by comma)

Let us know how this goes.