'Overdue more than 1 week' filter

Question

Hi everyone, I am trying to filter tickets in Jira that are overdue for more than 1 week post due date. Trying the syntax below but seems that this is not correct.

project="Digital Analytics" and status not in (Resolved, Closed, Done) AND due >= now("+7d")

Can someone please help to modify?

Alexander Ling_scml7y · Accepted Answer

Hello @Iwona Kalinowska

I tried some JQL searches and this one worked for me if I understand your requirements correctly. Please get back to me if it doesn't work.

project="Digital Analytics" and status not in (Resolved, Closed, Done) AND due < now() AND due <= -7d

I hope that this answer solves your issue! :-)

Best regards,

Alexander

Mark Arrowsmith_an5cmi · Accepted Answer

I like using statusCategory in those cases, rather than listing out all statuses that equate to done:

project="Digital Analytics" and statusCategory != Done AND due is not EMPTY AND due <= -7d

Cheers,

Mark