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

Question

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

Walter Buggenhout · Accepted Answer

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!

Ste Wright · Accepted Answer

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