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:

ORDER BY

CASE

     When clientPriorityRank > 0 then clientPriorityRank

     When clientPriorityRank is null then 0

END DESC

 

Best,

 

Ivan

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

Hello,

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.

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

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events