Hello Where abouts would I find the dates of all tickets that have become overdue in the database? This is so I can produce a line similarly to the built in line in the dashboard for overdue tickets.Many thanksCameron
Note I am able to find all of the tickets that are currently overdue however I cant find the tickets that are now closed but used to be overdue.
The dashboards data is based on the events and not the tickets themself
He's right, you're after something like
SELECT timestamp FROM PREFIX_thread_event WHERE state = 'overdue'
You'll want to JOIN that to the thread to get tickets details.
Thank you for this worked perfectly.