JQL Query to determine how long an item has been without a due date for?

[ryanzawada]

Hi im new to JIRA and working with query's and this one has been troubling me.

Basically I want to have a search function that will allow me to see a ticket that has been created with no due date set, and I can search for tickets that havent had a due date assigned for a period of 5 days, then 10 days, then greater then 10 days.

Any help would be greatly appreciated!

[Warren · Accepted solution]

Hi Ryan

To search for tickets created in the last 5 days that don't have a due date set, use

project = ABCD AND createdDate >= -5d and duedate is EMPTY

Replace -5d with -10d for the last 10 days.

Then for more than 10 days, use

project = ABCD AND createdDate < -10d and duedate is EMPTY

[ryanzawada]

Youre a life saver, thank you Warren!