Query to get Survey info with custom filter

Query to get Survey info with custom filter

Version : 10609
DB : MSSQL & PGSQL

OUTPUT:





SELECT wo.WORKORDERID AS "Request ID",longtodate(srm.responsetime) AS "Responded Date", longtodate(srm.SENDTIME) AS "Survey Created Time", smn.SURVEYNAME AS "Survey Name", AaaLogin.NAME AS "Username Received By",aau.FIRST_NAME AS "Survey Answered By" FROM SurveyResponseRequestMapping srrm INNER JOIN Survey_Response_Main srm ON srrm.RESPONSEID=srm.RESPONSEID LEFT JOIN Survey_Main smn ON srm.SURVEYID=smn.SURVEYID 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 AaaLogin ON aau.USER_ID = AaaLogin.USER_ID where smn.SURVEYNAME = 'testa'

      New to ADSelfService Plus?