Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
0
-
Description
Summary
Request to add a way of creating a JQL filter to show a list of open Epics, that have no open child tasks inside of them natively, without 3rd party add-ons.
Issue description
JQL does not natively support parent-child relationships in a single query.
Expected Results
Using native JQL with no paid add-ons.
Actual Results
Having to resort to paid apps to achieve desired results.
Workaround
You can achieve the above by running two separate queries and comparing the results.
1. Find all Open Epics:
To find all open Epics in your project, you can use the following JQL query:
issuetype = Epic AND statusCategory != Done
This will return a list of all open Epics in your project. You can save this filter for later use.
2. Find all Open Tasks with Open Epic Link:
To find all open tasks that are linked to any open Epic, you can use the following JQL query:
issuetype = Task AND statusCategory != Done AND "Epic Link" is not EMPTY
This will return a list of all open tasks that are linked to any Epic.
Now, to identify the Epics that have no open tasks, you would need to manually compare the two lists you obtained. Epics that appear in the first query, but not in the second query, are the ones without any open child tasks.
Workaround 2
Plugins like ScriptRunner or JQL Tricks should allow to achieve the requested functionality in 1 JQL line. Please reach out to add-on providers for details and documentation.
Attachments
Issue Links
- relates to
-
JRACLOUD-67108 JQL to filter issues with/without subtasks / child issues
- Gathering Interest