1 Reply Latest reply on Jul 9, 2018 1:04 PM by Brian Da Silva

    In the database, what fields determine work order status?

    MIke Methe

      All,

      I am trying to create some analytics (KPI) in Excel using a data model.  I am having trouble figuring out what combination of events sets a status to OPEN or CLOSED.  CLSDDATE and COMPLETED?  If they are both NULL is the ticket open?

       

      If anyone knows, I would appreciate the insight

       

      Thanks