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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Show up and give back by attending an Atlassian Community Event: we’ll donate $10 for every event attendee in March!
Join an Atlassian Community Event!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.