Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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?

1 answer

0 votes
John 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
TAGS
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

1,239 views 18 23
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