I have created a simple report to display tickets by Site, but how do I make it so its ordered by closed tickets.

 

I have the query below:

 

SELECT std.STATUSNAME "Request Status",sdo.NAME "Site",wo.WORKORDERID "Request ID" FROM WorkOrder wo LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wo.ISPARENT=1)

 

Thanks for the support

Todd Warner