How do I sort DESC with emptys last?

Question

There was a suggestion open in 2013 that references a similar request: https://jira.atlassian.com/browse/JRA-35284

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!

Franklin Davis · Answer

From @Chloe :

https://community.atlassian.com/t5/Jira-questions/How-to-order-issues-with-null-first-or-null-last/qaq-p/311131#M476723

It's frustrating to have this unfriendly sorting problem.

Please vote and watch the following issues if you have the same problem.

https://jira.atlassian.com/browse/JRACLOUD-72847

https://jira.atlassian.com/browse/JRASERVER-65848

Francisco_5fcqkv · Answer

perhaps joining two queries/searches/JQLs? - let me check..

=( after spending 38 min I did not find that answer, and I created a new 'discussion?':

https://community.atlassian.com/t5/Jira-Core-questions/In-JQL-how-to-quot-UNION-quot-i-e-pr-1-AND-status-done-UNION-pr/qaq-p/1162157

Angelica Krott · Answer

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.