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
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 ...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 ...Query for disabling survey link when accessing non login url (or) requires login for filing survey
update globalconfig set paramvalue='true' where parameter like '%Requireslogin%' and category like '%survey%'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 ...