Survey Percentage
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
New to ADSelfService Plus?
Related Articles
How to calculate satisfactory level for Survey
We are considering the rating value (Score) in the calculation of the survey Example : Suppose the Survey has 7 Questions with maximum of 10 Radio type points and each points carry above mentioned score. If customer clicks 9 for all 7 questions (that ...Survey Mail Configuration -> To insert Survey link to a text
You can follow the below steps to remove the Good and Bad in the Mail Configuration and to insert the Survey Link in the desired text. -> Go to Admin -> Survey Email Configuration. -> Select the Good and Bad there and delete the same. -> Enter the ...Query to find deleted survey (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Go to Reports >> New Query Report >> Run the below query to get the data SELECT err.message "System log message", err.errormodule "Module", err.suberrormodule "Sub Module", err.action "Action", ...How to schedule a Survey automatically after closing a ticket ?
We schedule a Survey after closing every ticket to know or rate our support to the customer. Steps to schedule a Survey: 1) Logo to the application as an administrator , In the Admin Tab -> Survey Configuration as shown in the below snapshot. -> In ...Behavior of Survey email configuration in 11.0
When Support reps setup survey email configuration, they would be under the impression that the language they select would the one the survey goes out but it doesn't work that way. Let's say that the Support rep sets up the survey to go out in the ...