Help Building JQL to Keep Status of Parent-Child Work Items in Alignment

[Mathew Lederman]

I need help building 2 queries:

1. Find parent-level work items where
   1. Parent-Level work item is not Done (statusCategory != Done) AND
   2. All sub-task work items are Done (statusCategory = Done)
2. Find all sub-task level work items where
   1. Parent-Level work item is Done (statusCategory = Done) AND
   2. All sub-task work items are not Done (statusCategory != Done)

Ideally, I'd like to only use natively available JQL so I can use these queries to build filters/dashboards.

[Marc - Devoteam]

Hi @Mathew Lederman 

To get a single parent issue you could do this: 

issue in portfolioChildIssuesOf("<issue-key>") and statusCategory = done

This will provide all child issues of a parent that are done

Or

issue in portfolioChildIssuesOf("<issue-key>") and statusCategory != done

This will provide all child issues of a parent that are not done

If you want to find all parents and child based on your required combinations, you will require a 3rd party app from the marketplace to extend you JQL options.

[Cristiano Alves -Appfire-]

Hello @Mathew Lederman ,

I'm Cristiano, with the Appfire team here,

if your only concern is to build filter, then the app our team works, JQL Search Extensions, will still help with that.

First the queries:

1.

issues in parentsOfIssuesInQuery("project='Wano' AND (issuetype = sub-task AND status = Done )") AND status != "Done"

2.

issue in subtasksOfParentsInQuery("Project='Wano' AND status='Done'") and status!='Done'

The main difference from native Jira is that these queries, from within the JQLSE app are dynamic. And as I said before, after searching from within the app, you are able to save the custom query as a filter and use it elsewhere with the:

filter=<filter name>

Feel free to contact our support team if you need help setting this up, or any further question about the app.