Need a Simple Report
Cab someone give me the code to create below quiry, I need it very urgently
TICKET_ID - TICKET_TITLE - TIME_TIKCET_IS_OPEN - TIME_TICKET_IS_CREATED - TICKET_PRIORITY - TICKET_ESCALATIO_MINUTES - TICKET_LAST_ESCALATION_TIME - TICKET_LAST_ESCALATIO_TO - TICKET_OWNER_NAME
1176 - PC Problem - 0d 2h 23m 20s - 0d 4h 53m 23s - Medium - 480 - 12/06/2011 4:23:11 PM - nsaghar@mtn.com.af - Bilal Ahmad Azizy
1179 - Hardware Problem - 0d 0h 32m 23s - 0d 0h 43m 43s - High - 240 - 12/06/2011 5:34:23 PM - zhamidy@mtn.com.af - Nisar Ahamd
Please make it a table you will understand what I mean, I will be really thankfull to o who can help me with this Issue,
Thanks in advance,
[sm=rolleyes.gif]
TICKET_ID - TICKET_TITLE - TIME_TIKCET_IS_OPEN - TIME_TICKET_IS_CREATED - TICKET_PRIORITY - TICKET_ESCALATIO_MINUTES - TICKET_LAST_ESCALATION_TIME - TICKET_LAST_ESCALATIO_TO - TICKET_OWNER_NAME
1176 - PC Problem - 0d 2h 23m 20s - 0d 4h 53m 23s - Medium - 480 - 12/06/2011 4:23:11 PM - nsaghar@mtn.com.af - Bilal Ahmad Azizy
1179 - Hardware Problem - 0d 0h 32m 23s - 0d 0h 43m 43s - High - 240 - 12/06/2011 5:34:23 PM - zhamidy@mtn.com.af - Nisar Ahamd
Please make it a table you will understand what I mean, I will be really thankfull to o who can help me with this Issue,
Thanks in advance,
[sm=rolleyes.gif]
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
mramsdell
12 years ago
Is this what you need?
SELECT HD_TICKET.TITLE,HD_TICKET.ID,HD_TICKET.TIME_OPENED,HD_TICKET.CREATED,HD_PRIORITY.NAME AS PRIORITY,HD_TICKET.ESCALATED,O.FULL_NAME AS OWNER_NAME,S.FULL_NAME AS SUBMITTER_NAME FROM HD_TICKET JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) ORDER BY TITLE,ID,TIME_OPENED
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
