Order by DESC with NULLS LAST

[Todd Alden]

Have spent WAY too much time trying to find this answer...

Simply:  I want to run a JQL query sorted by a priority number field, with highest numbers first and those with the priority field empty last in the sort order.

Should be something like this:  ORDER BY RPN DESC, NULLS LAST

Only JQL does not seem to support "NULLS LAST".  by default, the NULLS (entries with no RPN) are lised first when in DESC order.  For obvious reasons, I want those listed last.

Surely there is a way to do this?

[Nic Brough -Adaptavist-]

JQL is not SQL, and doesn't have such a function.  So, there's no way to do it, without writing a JQL function.

[Franklin Davis]

Vote for these two issues!

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