/build/static/layout/Breadcrumb_cap_w.png

Assistance with Report - SQL Query to populate data in feilds

I have a report that pulls the table in Service Desk.  The label for APPROVERS and APROVAL is there but the data is blank:


SELECT HD_TICKET.ID,
S.FULL_NAME AS SUBMITTER_NAME,
HD_TICKET.PARENT_ID,
HD_TICKET.IS_PARENT,
HD_TICKET.TITLE,
HD_TICKET.SUMMARY,
AP.FULL_NAME,
HD_TICKET.APPROVAL,
HD_TICKET.APPROVAL_NOTE,
IF(HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.IS_PARENT,
HD_SERVICE_STATUS.NAME, HD_STATUS.NAME) AS STATUS_NAME,
O.FULL_NAME AS OWNER_NAME,
HD_TICKET.CUSTOM_FIELD_VALUE1,
HD_TICKET.CUSTOM_FIELD_VALUE2,
HD_TICKET.RESOLUTION,HD_TICKET.CUSTOM_FIELD_VALUE0  FROM HD_TICKET  LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER AP ON (AP.ID = HD_TICKET.APPROVER_ID) LEFT JOIN HD_SERVICE_STATUS ON HD_TICKET.HD_USE_PROCESS_STATUS and HD_TICKET.HD_SERVICE_STATUS_ID and HD_SERVICE_STATUS.ID = HD_TICKET.HD_SERVICE_STATUS_ID LEFT JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 4)  ORDER BY ID


0 Comments   [ + ] Show comments

Answers (2)

Posted by: Hobbsy 4 weeks ago
Red Belt
0

Is it possible that there is no data in those fields?? Have you connected to the database and checked the HD_TICKET table to see if there is any data?

Posted by: mscott003 4 weeks ago
White Belt
0

I did find that the information i need is not in that table.  Since the Approval process is part of a process.  here is the info from Quest support but I don't have enough SQL skills to write the query:


Indeed, the process field is different from the regular field. For process, the table for app-rover information is on a different table, which is HD_TICKET_APPROVAL.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ