Provided query is not executing

Provided query is not executing

Below Provide query is not working:-

select wo.WORKORDERID 'Request ID',TITLE 'Title', DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000) ,'%d-%m-%Y %k:%i') 'Created Time',DATE_FORMAT(FROM_UNIXTIME(wo.COMPLETEDTIME/1000) ,'%d-%m-%Y %k:%i') 'Completed Time', MODENAME 'Mode', STATUSNAME 'Status', aau.FIRST_NAME 'Technician', DATE_FORMAT(FROM_UNIXTIME(woh.OPERATIONTIME/1000) ,'%d-%m-%Y %k:%i') 'Operation Time',woh.OPERATION,aau1.FIRST_NAME 'Updated By' from WorkOrder wo LEFT JOIN ModeDefinition md ON wo.MODEID = md.MODEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID LEFT JOIN StatusDefinition sd on wos.STATUSID = sd.STATUSID LEFT JOIN SDUser sdu on wos.OWNERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID = woh.WORKORDERID LEFT JOIN SDUser sdu1 ON sdu1.USERID = woh.OPERATIONOWNERID LEFT JOIN AaaUser aau1 ON sdu1.USERID = aau1.USER_ID where woh.OPERATION like '%UPDATE' order by 7

NOTE:- I am trying to execute this query from query editor. Is any other process require to execute this query ???

-- Trisha





                      New to ADSelfService Plus?