Hi all,

I located the below query on the site and it works great. It allows you to generate a report which includes "Survey %". I'm wondering if anybody can expand the query to also include the survey comments?

SELECT wo.WORKORDERID AS "Request ID",

       max(wo.TITLE) AS "Request
Title",

       max(aau.FIRST_NAME) AS
"Requester",

       max(ti.FIRST_NAME) AS
"Technician",

       longtodate(max(wo.completedtime))
AS "Completed Time",

       longtodate(max(srm.Responsetime))
AS "Survey responded Time",

       max(srm.result) "%"
FROM SurveyResponseRequestMapping srrm

INNER JOIN Survey_Response_Main srm ON srrm.RESPONSEID=srm.RESPONSEID

LEFT JOIN Survey_Response_Answer sra ON srm.RESPONSEID=sra.RESPONSEID

INNER JOIN Survey_Question sq ON sra.QUESID=sq.QUESID

LEFT JOIN WorkOrder wo ON srrm.WORKORDERID=wo.WORKORDERID

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID

LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID

LEFT JOIN SDUser td ON wos.OWNERID=td.USERID

LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID

GROUP BY wo.WORKORDERID

Thanks,

Shawn