I am writing a filter to list parent issues if any of the sub-tasks are still active.
i.e. I want to exclude issues if there are no sub-tasks or if all the sub-tasks are already closed.
Please do not suggest a 3rd party app, I do not have a budget to purchase such.
Thank you for your advice.
Hi @Patrick Till - Unfortunately, to achieve this purely with JQL you would need a marketplace app. However, there is a workaround that you can employ leveraging some native automation:
You'll need some mechanism that will "tag" the parent issue when all sub-tasks are resolved. This could be a custom field, component, label, etc. For my example, I'm going to use a custom field of type label called "System Labels" which is hidden from the issue screens as I only need it for querying purposes. Now for the automation...
resolved IS NOT EMPTY
Quick explanation on the rule:
You'd need to create another one-time rule that processes all current issues as well (modify the trigger query as needed to cover any custom issue types you may have).
Type IN (Story, Task, Bug) AND resolved IS NOT EMPTY
resolved IS NOT EMPTY
Once that's set, you would incorporate this into your query:
("System Labels" IS EMPTY OR "System Labels" NOT IN (subtasks_resolved)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.