/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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