JQL order null values

Ivan Bambov February 4, 2018

Hi All,


is there a way to order null/empty values after the ones with value using JQL

Possibly something like:



     When clientPriorityRank > 0 then clientPriorityRank

     When clientPriorityRank is null then 0






2 answers

1 accepted

1 vote
Answer accepted
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 4, 2018


It is not possible in JQL. All you can do is to order by a field using ASC, DESC

Brian Krug January 17, 2020

Why is it not possible? ThHis would be a very useful and commonly needed functionality. We use a custom field that designates a certain priority order as a number but it is often empty and I want to sort by highest number first and then the empty values at the end and can't do it in Jira.

Like # people like this
5 votes
Chloe April 5, 2021

It's frastrating to have this unfriendly sorting problem.

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



Suggest an answer

Log in or Sign up to answer