I want to see a list of all epics in a project ranked by the number of issues in that epic. Is that possible with JQL or otherwise?
We are using Jira Cloud.
Add a comment
|
2 Answers
-- For Jira Server --
In your Issues search section, go to the Columns selector and choose to include the field "Issues in Epic" in your results. Then run this JQL:
project = YOUR_PROJECT AND issuetype = Epic ORDER BY "Issues in Epic" ASC
The sort does not work properly because (I assume) the field is stored as a string in Jira, so it's in alphabetical order. But you can then export your results as a CSV file and open it with Excel, who has no issues in sorting properly by the numerical value.
-
Sorry, I get the error
Not able to sort using field 'Issues in Epic'.. Is that field only available on Jira Server?– fredNov 9 at 16:33 -
1I got the same error as @fred using Jira Cloud. Tried to see if it would work using "Child issues" but it didn't. Nov 9 at 19:09
-
I'm on Jira Server, yes. But even with Jira Cloud, the difference should be on the hosting, or direct access to the database. But the implementation should be the same. Can you at least see the "Issues in Epic" field in the Columns selector? If you can, you can remove the
ORDER BY "Issues in Epic" ASC, and then sort in Excel on the exported CSV.– BogdanNov 9 at 19:13 -
-
Try this query " project = "" AND issueType = epic ORDER BY issueCount DESC "
It will return, from highest to lowest a list of all epics in the specified project, ordered by the number of issues in each epic.
you can filter the results to only include epics that have been created in the past week, or epics that are in a specific status.
every query input above but replace the second equals to with " = epic AND created >= 2023-11-10 ORDER BY issueCount DESC
-
-
🤔 that maybe because the Jira Cloud instance used does not support sorting by the "issueCount" field. Nov 11 at 12:29