List all user stories under each EPIC - group by Epic

[Harsha Vardhan]

HI , 

How do I write a JQL to get 

all user stories listed under each and every epic . 

Example 

EPIC 1 

user Story 1 

user Story 2 

EPIC 2 

User Story 1

User Story 2

[Dave Rosenlund _Trundl_]

@Harsha Vardhan: As @Alexey Matveev mentions, one of the most popular ways to create custom hierarchies, and build cross-project views of same, is by using Structure for Jira (exactly what this Jira app was designed to do).

Should you decide to evaluate Structure, the support team here at ALM Works would be happy to answer any questions you may have.

Best of luck to you.

-dave [ALM Works]

[Junio Fernandes]

As I answered you on another post...

You need to explain your needs, because when you say "create a report" I can understand a new addon, or maybe an msexcel integration, or use of rest api, or just search for issues. 

That said, you can't group it in issue search, but showing correlated columns you should get it and export to excel sheet and use of pivot's table to group the items.

[Alexey Matveev]

Hello,

JQL can not create hierarchies. It is just a query. You can create a software board and then configure a swimlane, based on epics. You will see the picture, which you require.

Or you can use such plugins as Structure, Portfolio, Big picture to make a hierarchy out of issues.

[Junio Fernandes]

Sorry. I edited this post because I wanted to reply the question directly.

[Harsha Vardhan]

Seems to be not a great tool ! Looks congested by default.