nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Mike Maurer

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.

All comments

Mike Maurer

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.

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)

boellner boellner

thank you! this worked out

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

jira-data-center

data-center