Is there an 'On Hold' ticket status available in osTicket?
Not natively. You can create a custom status named 'On Hold' but it will map to an underlying state of Open, Closed, or Resolved -- there is no true On…
FAQ Category: General
What database table and fields hold the ticket 'assigned' value? Trying to query time from ticket creation to assignment.
Use the official database ERDs at https://docs.osticket.com/en/latest/Developer%20Documentation/Database%20ERDs.html. The assignment event is tracked via the thread system: ost_ticket → ost_thread (where object_id = ticket's primary key/ticket_id and object_type = 'T') →…