JQL to show overdue Issues plus Issues that have a Due date within the next 7 days

[Brad Mancini]

Hi team,

The following JQL filter does not achieve what we were hoping:

duedate < startOfDay(7d) AND resolution = Unresolved

This is used as a Quick Filter on a Board.  The intent was to show only overdue Issues and Issues that have a Due date within the next 7 days. 

Unfortunately Issues show up with no "Due date" defined:

Do you know what I'm doing wrong?

Many thanks,

Brad

[Ste Wright · Accepted solution]

Hi @Brad Mancini 

This should work, because it needs a due date to be populated to work:

resolution is EMPTY AND duedate <= 7d

But if it doesn't, specifically state the due date can't be empty:

resolution is EMPTY AND duedate is not EMPTY AND duedate <= 7d

Ste

[Brad Mancini]

Thanks Stephen! 

I found that the main issue was that the Due Date displayed on the Default Issue Screen was not the right one.  I swapped this field with the correct "system" Due Date and all was behaving as expected.  The following JQL is working perfectly now:

resolution = Unresolved AND duedate is not EMPTY AND duedate < startOfDay(7d)

Thanks again.

Cheers,

Brad

[Walter Buggenhout · Accepted solution]

Hi @Brad Mancini and welcome to the Community!

You should be able to work around that by adding an explicit clause to exclude these empty items:

Resolution = Unresolved AND (duedate IS NOT EMPTY OR duedate < startOFDay(7d))

Hope this helps!

[Brad Mancini]

Thanks so much for your reply Walter.  

Great idea regarding "duedate IS NOT EMPTY".  I added this :-)

It ended up being slightly more complicated.  I found that the Due Date that was displayed on the Issue screen was NOT the system Due Date.  It seems to be a custom field.  I have no idea why it was there.  You can see in the Configuration of the Default Issue Screen there were TWO Due Dates.  That's a nice way to get confused ;-) 

I swapped these Due Dates - and now use the "system" Due Date. 

I ended up with the following, which works now.

resolution = Unresolved AND duedate is not EMPTY AND duedate < startOfDay(7d)

Thanks again for your help Walter.

Have an awesome day.

Best regards,

Brad