How to sort issues by their priorities

[levaxuco]

Hello,

I have given priories to all issues/tasks (from 1 - to 5) now I want to sort them (in an ongoing sprint) by priorities - high to low. which query should I write? 

this one doesn't work => project = MyAwesomeProject ORDER BY priority DESC"

and this one also not working ORDER BY RANK

[Ignacio Pulgar · Accepted solution]

For doing so in Active Sprints, follow these steps:

1. Go to Board > Configure > Swimlanes
2. Base swimlanes on Queries
3. Set one JQL query for each priority (ie: 'priority = Blocker')

[Nic Brough -Adaptavist-]

I assume your priorities are done with the system field called "priority"?

This is a field that has a sort order defined by the admin, not by the content, so your order by clause will be working off that sort order, not 1, 2, 3, 4, 5 (although, as an admin, I would be setting that sort order)

Can you check that it is the system priority field that is in use, and what the sort order for your options are?