'Overdue more than 1 week' filter

[Iwona Kalinowska]

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?

[Mark Arrowsmith · Accepted solution]

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

[Alexander Ling · Accepted solution]

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

[Alexander Ling]

You can probably remove the "due < now()" now that I look at it again.

[Iwona Kalinowska]

Worked! thanks a lot Alexander :)