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

Question

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.

Faizan Sayyed · Answer

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.

Marc -Devoteam- · Answer

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