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.