Order by Priority

andycaseASA March 7, 2021

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?

2 answers

1 accepted

2 votes
Answer accepted
Deepanshu Natani
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 7, 2021

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

andycaseASA March 7, 2021

Yes of course, thanks

Like Deepanshu Natani likes this
Ignacio Cobos Rey November 10, 2022

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.

Like Mosh Feu likes this
0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 8, 2021

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 November 10, 2022

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. 

Like Mosh Feu likes this
Mosh Feu March 9, 2023

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

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 9, 2023

You would need to submit a support ticket for that.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events