/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] 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
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