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 ?

      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.

        KevinTheJedi
        I have 2 question here,

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

        Thank you

          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 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

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

                  Thanks & Regards
                  Johnson

                  Write a Reply...