JQL - Filter subtasks when the parent story or task's status is "Done."

Question

I want to query subtasks with the status "Ready To Deploy" when the parent story or task's status is "Done." This is my JQL, but it doesn't work.

project = "XX" AND issuetype in subTaskIssueTypes()

and status = "READY TO DEPLOY"

and parent in (

issueFunction(issuetype = story, status = DONE) )

ORDER BY created ASC

Prosper Agwegiokhe · Answer

Hi @Fikra,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.
Unfortunately, natively, you’ll not be able to do it dynamically. However, in the app my team works, JQL Search Extensions for Jira, you can use the query below to get your desired results:

project = XX and issue in subtasksOfParentsInQuery("type in (Story,Task) and status = Done") and status="Ready To Deploy"

Please contact our support if you have any other questions about this query.
We’ll be happy to help you!

Best regards.

Fikra · Answer

Thanks in advance @Trudy P Claspill . I decided to use" parent in", even though I have to list the all stories down.

Trudy P Claspill · Answer

If you have only native Jira functionality you will not be able to create one filter to get those results. You could create one filter to get the parent issues and export those results.

Use can then use the list of parent issue keys from that filter as input to your filter for subtasks. To the JQL you have you would add

and parent in (<insert comma separated list of parent issue keys>)

To get what you want from a single JQL statement would require a third party app.