Order by Priority

[andycaseASA]

Order by Priority

Our organisational priority settings are

• Highest
• High
• Medium 
• Low
• Lowest

I want to list all my JIRA issues in the above order. What JQL script can I use to order the list?

[Deepanshu Natani · Accepted solution]

Have you tried adding the following to your JQL query? : order by priority DESC

[andycaseASA]

Yes of course, thanks

[Ignacio Cobos Rey]

That yields the pririority ordered alphabetically which is not the order of priority. If you have Priority High, Medium, Low, with your solution it would be ordered as High, Low, Medium, which is the wrong order. Surprisingly when opening the dropdown for priority in a ticket the priorities are correctly sorted, so there is an internal index to sort them but JQL can't access that internal index, and the tag "priority" points to the NAME of the priority, what makes your solution not to deliver the expected results.

[John Funk]

Hi Andy,

Unfortunately, the order by is just going to put them in alphabetical order - either ascending or descending. 

So you will need to add a number in front or letter or something to get them in a particular order. Something like:

1 - Highest
2 - High
3 - Medium
4 - Low
5 - Lowest

[Ignacio Cobos Rey]

This is so wrong... 🤦‍♂️ The dropdown to select priority in a ticket is already ordered correctly. So THERE IS a way to order this. It's just that JQL can't access this order. 

[Mosh Feu]

@John Funk is there a plan to allow sorting by priority for real?

[John Funk]

You would need to submit a support ticket for that.