I need to write a query to get Epics and sort them with stories underneath - E1 (S1,2,3)E2(S1,2))

[Saurabh]

I need to write a query to get Epics and sort them with stories underneath - E1 (S1,2,3)E2(S1,2)) and so on -hopefully sort by Priority 

This didn't work 

project = xxxx And issuetype in (Epic,Story) Order by rank Asc,priority DESC

[Bill Sheboy]

Hi @Saurabh  -- Welcome to the Atlassian Community!

This is not as easy as it should be with Jira.  JQL is not actually SQL...

There are marketplace add-ons which could help do this.

A work-around without an add-on would be to add a custom-field which is populated from either the Key for an epic or the Epic Link for a story.  Then, sort with ORDER BY your-custom-field ASC, IssueType DESC, Key ASC.

Best regards,

Bill

[Saurabh]

Thanks for your response Bill-much appreciated !! I'll try this and get back.