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!!
Match the status_id to the id in the _ticket_status table.
We have database ERDs here:
Cheers.
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
;