Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

order by priority not ordering by priority



I am trying to search for issues and order by priority.

ORDER BY priority DESC

but when i do they get ordered but not by priority.

The way they are ordered is:

  1. "Major"
  2. "Not Set"
  3. "Critical"
  4. "Blocker"
  5. "Minor"
  6. "Trivial"
  7. "High"
  8. "Low"

How can i order them so that they are ordered by [what i perceive to be the correct order]: 

  1. "Blocker"
  2. "Critical"
  3. "Major"
  4. "High"
  5. "Low"
  6. "Minor"
  7. "Trivial"
  8. "Not Set"



1 answer

1 accepted

1 vote
Answer accepted

Hi @Michael Aroustian,

Can you please check the Priorities admin menu? If you're a Jira admin, you can see it here:

You can see that priorities are ordered with the most important one at the top and the least important one in the bottom. You can re-order priorities using arrows:

Capture d’écran 2022-05-16 à 17.26.10.png

Hope this helps!

- Manon

Like Manon Soubies-Camy likes this

Glad it helped :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

14,465 views 37 44
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you