JQL to list Epics and child stories in a nested format

Question

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 · Answer

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

unknown · Answer

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

Anton_Ermolaev · Answer

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.