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.
Project Management Stack Exchange is a question and answer site for project managers. It only takes a minute to sign up.Sign up to join this community
-- 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.
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