Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Order by duedate but duedate = null at the bottom

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 M Funk Community Leader Dec 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
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

124 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you