Survey Overview Report showing Error
Uses this query:
SELECT wo.TITLE "Request Title",aau.FIRST_NAME "Requester", DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000),'%d-%m-%Y %k:%i')"Request Created Time",ti.FIRST_NAME "Technician",DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000),'%d-%m-%Y %k:%i') "Completed Time",sum(sadt.RATING) "Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.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 1
Gets this error:
'FROM_UNIXTIME' is not a recognized function name.
SELECT wo.TITLE "Request Title",aau.FIRST_NAME "Requester", DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000),'%d-%m-%Y %k:%i')"Request Created Time",ti.FIRST_NAME "Technician",DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000),'%d-%m-%Y %k:%i') "Completed Time",sum(sadt.RATING) "Rating" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.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 1
Gets this error:
'FROM_UNIXTIME' is not a recognized function name.