How to identify and report overdue tickets

[Lauri Pantos]

Is there anything built into JIRA (cloud based, team managed) where I can create a report that checks for this

---

status in (Approved, "In Progress", "In progress", "To Do", "Waiting for Internal Approval", "Waiting for customer") AND statusCategory in (2, 4) AND due <= -2d

----

and then automatically sends each assignee a report of their overdue tickets daily?

Or is there an app youecommend?

I had been using e-reminders but when I switched to a next gen project, it stopped working correctly.

Thanks.

[Walter Buggenhout]

Hi @Lauri Pantos,

Through Filters > Advanced Issue Search create a filter like this:

status in (Approved, "In Progress", "In progress", "To Do", "Waiting for Internal Approval", "Waiting for customer") AND assignee = currentUser() AND due <= -2d

I am not sure what you want to do additionally with 'statusCategory' as you already an explicit list of statuses there, so I would just drop that part of the query.

Save the filter and after that, from the filter details create a filter subscription for the group of users you want to receive a daily update. You should be able to schedule the frequency to send out the daily mail.

Hope this helps!