Doubt about status ID <==> description table

eksoft

Hello there, I have a simple doubt: I'm looking of the tables for anyone that I can use to match 'status_id' with his description, such as 'open', 'closed', etc.

I'm designing a MySQL Workbench consult to perform an inform that I can use to evaluate my agents, but I at this moment, my inform shows Status as '1', '2', etc.

Any one have this information?

Thank you a lot!!

KevinTheJedi

eksoft

Match the status_id to the id in the _ticket_status table.

We have database ERDs here:

https://docs.osticket.com/en/latest/Developer%20Documentation/Database%20ERDs.html

Cheers.

eksoft

KevinTheJedi
Thank you a lot!!.

I share my base consult if it's util for anyone:

SELECT A.ticket_id, B.number, A.reporta, A.subject, A.c_modalidad, C.firstname, B.created, A.h_programada, A.h_viaje, A.h_inicio, A.h_fin, B.closed, D.name
	from ost_ticket__cdata AS A
JOIN ost_ticket AS B
	on A.ticket_id=B.ticket_id
JOIN ost_staff AS C
	on B.staff_id=C.staff_id
JOIN ost_ticket_status AS D
	on B.status_id=D.id
WHERE
	A.h_programada >= cast('2024-01-01' AS DATE)
	AND
	A.h_programada <= cast('2024-02-29' AS DATE)
ORDER BY A.h_programada
;