Order by duedate but duedate = null at the bottom

[Pascal Laub]

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?

[John Funk]

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. 

[Franklin Davis]

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