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
Query on displaying columns in percentage values
PGSQL: SELECT aau.first_name AS "Technician", Count(wo.workorderid) AS "Total No. of Tickets Created", Sum(CASE WHEN std.internalname LIKE 'closed' THEN 1 ELSE 0 END) ...Stage transitions based on task completion
Say goodbye to manual stage updates! This solution automates stage transitions based on task completion, saving you time and effort. Utilizing custom task functions and triggers, we can automate stage advancement based on task completion. The ...Restore Related Issues
1. Violation of PRIMARY KEY constraint 'ViewConfiguration_PIDX_PK' 2. Incorrect syntax near the keyword 'key'.java.sql.BatchUpdateException: Incorrect syntax near the keyword 'key' 3. Violation of UNIQUE KEY constraint / Cannot insert duplicate key ...Project,Milestone and Tasks.
DB Compatability: PgSQL and MSSQL SELECT projectdet .PROJECTID "Project Id", projectdet.TITLE "Project Title", projectstatus.STATUSNAME "Project Status", projectowner.FIRST_NAME "Project Owner", ...6. Database Schema
Request Module Column Name Column Value Joining Table Request ID wo.workorderid workorder wo Request Subject wo.title workorder wo Request created time longtodate(wo.createdtime) workorder wo Request category cd.CATEGORYNAME LEFT JOIN ...