It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I sort DESC with emptys last?

There was a suggestion open in 2013 that references a similar request:

How do I use a JQL statement to ORDER issues by priority DESC with the empty priorities appearing last?

For example, right now I have to have two separate Filters, one where "priority = EMPTY" and one where "priority != EMPTY" so that I can effectively see issues that are explicitly marked as the most important. Both filters have ORDER BY priority DESC.

What am I missing? Thank you!

1 answer


          Please try 

priority is not EMPTY ORDER BY priority DESC


priority is EMPTY ORDER BY priority DESC


Hope this helps


Chander Inguva

This doesn't appear to do what the person asked? They want a completed value to appear before null values. I'm having the same issue with date fields.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Calling all Jira Cloud users! Give us feedback on our exploration of a new navigation.

Hi everyone! My name’s Matt and I’m a product manager at Atlassian. I work in the navigation & findability space for all our Jira Cloud products. We’ve been working on trying to improve the exp...

959 views 15 12
Join discussion

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