Report to show tickets created after 24 hours and no comments or resolutions by technician
I need a report that show tickets that have no resolution or comments made by the technician 24 hours after the ticket has been opened and until a comment or resolution has been made. This way I can manage and keep up on the tech tickets without having to go into each ticket. I keep gettin SQL error code when trying to look at comments.
Community Chosen Answer
See if this does what you need.
Hope that helps!
SELECT T.ID AS TICKET_ID, T.TITLE, T.RESOLUTION, TC.COMMENT
FROM HD_TICKET T
LEFT JOIN HD_TICKET_CHANGE TC ON (TC.HD_TICKET_ID = T.ID)
WHERE DATEDIFF(NOW(), T.CREATED) > 1
AND ((T.RESOLUTION = '') OR (TC.COMMENT = ''))
GROUP BY T.ID
ORDER BY T.ID