Hi,

I'd like to sort this query (report) ascending by created time. Can you help me?

SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",wo.CREATEDTIME "Created Time",ti.FIRST_NAME "Technician",pd.PRIORITYNAME "Priority",lvd.LEVELNAME "Level",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",wo.TITLE "Subject",wotodesc.FULLDESCRIPTION "Description" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((cd.CATEGORYNAME = 'IJ') AND ((std.STATUSNAME != 'Gesloten') OR (std.STATUSNAME IS NULL)))  AND wo.ISPARENT=1  ORDER BY 1, 5, 3

Thanks in advance,

Kind greetings,

Ineke Folkertsma