Changing sorting order in a report
Hi Guys,
I am trying to edit a report we have for displaying the last update time of any request and by which technician:
SELECT wo.WORKORDERID 'Request ID',max(wo.TITLE) 'Subject',longtodate(max(wo.CREATEDTIME)) 'Created Time',longtodate(max(woh.operationtime)) 'Last Updated Time',au2.FIRST_NAME 'Last Updated By' FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID left join workorderhistory woh on wo.workorderid=woh.workorderid left join workorderhistorydiff wohd on woh.historyid=wohd.historyid left join aaauser au2 on woh.operationownerid=au2.user_id WHERE wo.ISPARENT=1 and woh.operationownerid !=1 group by wo.WORKORDERID
I would like to add a column that also shows the status of the request and i would like it sorted by the last update time/date rather than by request ID as it is at the moment.
Thanks!
I am trying to edit a report we have for displaying the last update time of any request and by which technician:
SELECT wo.WORKORDERID 'Request ID',max(wo.TITLE) 'Subject',longtodate(max(wo.CREATEDTIME)) 'Created Time',longtodate(max(woh.operationtime)) 'Last Updated Time',au2.FIRST_NAME 'Last Updated By' FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID left join workorderhistory woh on wo.workorderid=woh.workorderid left join workorderhistorydiff wohd on woh.historyid=wohd.historyid left join aaauser au2 on woh.operationownerid=au2.user_id WHERE wo.ISPARENT=1 and woh.operationownerid !=1 group by wo.WORKORDERID
I would like to add a column that also shows the status of the request and i would like it sorted by the last update time/date rather than by request ID as it is at the moment.
Thanks!