I have to run a report each month on how many work orders our Help Desk closed for the previous month. How can I create this report where I can specify the Date Range?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Also, how to I add the Department to this report? My users all have their departments listed under Custom 3 in their details. The report has this line (select FULL_NAME from USER where HD_TICKET.SUBMITTER_ID = USER.ID) as SUBMITTER_NAME Can I somehow change the HD_TICKET.SUBMITTER_ID=USER.ID to HD_TICKET.SUBMITTER_ID=Department or HD_TICKET.SUBMITTER_ID=Custom 3 ???
Answered 02/10/2011 by: jmcelvoy
Second Degree Blue Belt

Please log in to comment
0
I think this should point you in the right direction.
SELECT U.CUSTOM_3 AS DEPARTMENT,
COUNT(*) AS CLOSED_TICKETS
FROM HD_TICKET H,
HD_STATUS S,
USER U
WHERE H.HD_STATUS_ID = S.ID
AND H.SUBMITTER_ID = U.ID
AND S.STATE = 'CLOSED'
AND ( H.TIME_CLOSED >= '20110101'
AND H.TIME_CLOSED <= '20110131' )
GROUP BY U.CUSTOM_3
Answered 02/11/2011 by: dchristian
Red Belt

Please log in to comment
0
Works perfectly. Thanks.
Answered 02/14/2011 by: jmcelvoy
Second Degree Blue Belt

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