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]
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
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

Answered 02/27/2012 by: mramsdell
Orange Senior Belt

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