nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

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

Accepted answers

All comments

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud