Order by duedate but duedate = null at the bottom

Question

For all my unresolved issues in a project I want to show a filter. I developed in JQL the following:

project = PRJ AND resolution = Unresolved AND assignee in (currentUser()) ORDER BY duedate, priority, updated DESC

Problem is that we have a lot of backlog tickets which dont have a due date (yet). All of the issues with a due date should be at the top, the ones without a due date at the bottom.

And I cant achieve that yet. What is the solution here?

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

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

John Funk · Answer

Hi @Pascal Laub  - You would need to use the ASC instead of DESC to get the nulls at the bottom, which, unfortunately, will change the order of the issues that actually have a Due Date.

Your other option is to use a filter that specifically ignores issues with no due dates (duedate is not empty). You could create another board that uses that filter for times you want to just see issues with due dates.