How to generate dashboard report

johnson-chong

How to find the the overdue data that dashboard show. i have check from the database ticket table. The duedate was empty because once ticket is closed it will be cleared.
How the dashboard still able to get the data ?

KevinTheJedi

johnson-chong

There is an overdue event in the event table. You find ticket > thread > thread_events where event_id is the overdue event id.

Cheers.

johnson-chong

KevinTheJedi
I have 2 question here,

i have check on thread_events.event_id, where to find the meaning of the number ?
How the thread table link with ticket table. what I mean is which thread match with which ticket.

Thank you

ntozier

Ticket due date and estimated due date is in the ost_ticket table.
duedate and est_duedate fields.
Without looking at the code I'm not sure which one the dashboard is referencing.
The ticket will also be marked with isoverdue = 1.

It's likely it is also cached in the ost_ticket__cdata table.

johnson-chong

ntozier
Thanks for your reply. yes ticket have isoverdue = 1 but when the ticket is closed the value because 0.
The ticket_cdata table only have the subject, unable to find the overdue ticket.

Thanks & Regards

KevinTheJedi

johnson-chong

From the _event table.
You can find the ERDs here.

Cheers.

johnson-chong

KevinTheJedi For question 1 found it. Thank you
For question 2, I have look from the ERDs, I unable found any key can link thread and ticket. here is the diagram
need some assist.

Thanks & Regards
Johnson

KevinTheJedi

johnson-chong

It’s right there in the photo and even includes a little note.

Cheers.

johnson-chong

Sorry, i still can't get it.
How to thread_id join to ticket number?

Thanks & Regards
Johnson