JQL to list Epics and child stories in a nested format

[Soham Bose]

I'm trying to do a query for the EPIC and child Stories within that Epic so it displays nicely. For example:

• Epic A
  • Story A1
  • Story A2
• Epic B
  • Story B1

Right now I have "Epic Link" in (E-1, E-2) OR issuekey in (E-1, E-2), however this just lists the objects in the order they were created. Is there a way to sort this to display like above? 

[Anton_Ermolaev]

Just in jql - impossible.

But you can create and save filter like:

"Epic Link" in ("Epic A","Epic B") order by "Epic Link" , summary desc

then create report "Single Level Group By Report" with this filter and group by Epic link.

It's gonna be very similar to what you want to see.

[Soham Bose]

Is it possible to group filters? Similar to grouping favorites in a web browser within a folder?

[Anton_Ermolaev]

Soham, unfortunately not. You need something like GROUP BY, but JQL doesn't have it. You can filter by JQL and then group it filter by report.

Read similar topic: https://community.atlassian.com/t5/Jira-questions/JIRA-JQL-use-the-group-by-function/qaq-p/549449