JQL Query to find where one Sub-Task is closed

[boellner boellner]

Hello,

I have this structure

many Stories
   |- 1 Subtask Summary A
   |_ 1 Subtask Summary B

I am looking for a query to find all of those Stories that have Subtask A closed and 
Subtask B in status open.

What would be the query for it?

Thank you

[Mike Maurer · Accepted solution]

I believe with pure JQL this is difficult. Do the subtasks have specific names?

To find Stories where Subtask A is closed and Subtask B is open, you’ll likely need a plugin like ScriptRunner. Something like:

issueFunction in parentsOf("type = Sub-task AND summary ~ 'Summary A' AND status = Closed")
AND issueFunction in parentsOf("type = Sub-task AND summary ~ 'Summary B' AND status = Open")

If you don’t have plugins, you could use Jira Automation:

• Manual Trigger.
• Add conditions to check Subtask A is "Closed" and Subtask B is "Open".
• Mark or tag the parent Story.
• Filter for the tagged issues.

[boellner boellner]

thank you! this worked out

[Carlos Garcia Navarro]

Hi @boellner boellner ,

Welcome to the Community! This can't be done with Jira out-of-the-box, so you may need an add-on. Mike's suggestions are good!

Sharing the link to these other posts for reference, his may provide some other alternatives or workarounds (e.g. exporting to a spreadsheet if this is a one-off task):

 https://community.atlassian.com/t5/Jira-questions/Query-for-open-stories-with-closed-sub-tasks/qaq-p/1133556

https://community.atlassian.com/t5/Jira-questions/Filter-for-open-subtasks-where-parent-is-closed/qaq-p/918110

https://community.atlassian.com/t5/Jira-questions/How-to-find-all-subtasks-under-standard-tickets-with-a-status-of/qaq-p/2530335

Note: For Jira Cloud the issueFuntion can be used as part of the enhanced search functionality (https://community.atlassian.com/t5/Jira-questions/Do-we-have-any-substitute-for-issuefunction-in-JIRA-Cloud/qaq-p/1539971)