Hi, I know how to create a report of tickets closed in the last 24 hours the only thing I am having trouble with is having the report only show 2 certain users on it

Thanks
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

1
This query uses the HD_TICKET_CHANGE table to find tickets where the status was changed to "Closed" by specific users:
SELECT T.ID, T.CREATED, T.TIME_CLOSED, OWNER.FULL_NAME as "Owner", 
CLOSED.TIMESTAMP, CLOSED.DESCRIPTION,
CLOSER.FULL_NAME as "Closer"
FROM ORG1.HD_TICKET T
LEFT JOIN HD_TICKET_CHANGE CLOSED ON CLOSED.HD_TICKET_ID = T.ID and CLOSED.DESCRIPTION like '%Changed ticket Status from%to "Closed"%'
LEFT JOIN USER OWNER ON OWNER.ID = T.OWNER_ID
LEFT JOIN USER CLOSER ON CLOSER.ID = CLOSED.USER_ID
WHERE T.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 1 DAY)
AND (CLOSER.USER_NAME = "user1" or CLOSER.USER_NAME = "user2")

Answered 02/19/2016 by: chucksteel
Red Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity