Dear Help,

The following MSSQL statement below produces report 1. We would like it amended to produce report 2 please. It’s important however that the ‘Responded Date’ is not the automatic generated response from the application. It has to be a note or work log entry from a technician.

Thanks for looking,

Stef

SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",dateadd(s,wo.CREATEDTIME/1000,'01-01-1970')  "Created Time",dateadd(s,wo.COMPLETEDTIME/1000,'01-01-1970') "Completed Time",dateadd(s,wo.RESPONDEDTIME/1000,'01-01-1970') "Responded Date" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID 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 WHERE (wot.THD_WOID=wot.WORKORDERID)

Report 1

Report 2