ordering null value

[Carolina SILVA]

Hi,

When I have null values it is always considered as highest values.

1. When I order in ASC, null values are at the end
2.  When I order in DESC, null values are at the begin

Is there a way that JIRA consider null values the lowest to be able to put in in the correct order?

thanks for your help

[Cristian Ionescu · Accepted solution]

Hi,

In JQL NULL=Empty like. Base on your situation you cannot make a sorting ASC or DESC base on a Empty field. You need to find another field that may help you and them sort the issues.

[Carolina SILVA]

Thanks Cristian. I decided to set a default value (0) versus empty one

[Cristian Ionescu]

You're welcome Carolina

[Franklin Davis]

From @Chloe 

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