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. 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4

See if this does what you need.

Hope that helps!

John

________________________

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

Answered 06/11/2012 by: jverbosk
Red Belt

Please log in to comment

Answers

1

Can you post the code that you have now?

Answered 06/11/2012 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity