Order by duedate but duedate = null at the bottom

Pascal Laub December 21, 2020

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?

2 answers

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 21, 2020

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. 

Suggest an answer

Log in or Sign up to answer