Modify query
Hi,
I'm using the query below to report on monthly #tickets per status (closed, on hold, resolved, open)
I'd prefer to have this same report generated _per week_ to allow for some more fine-grained info.
Anyone here savvy enough to help me out?
SELECT std.STATUSNAME "Request Status",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 3
Thanks,
Will
I'm using the query below to report on monthly #tickets per status (closed, on hold, resolved, open)
I'd prefer to have this same report generated _per week_ to allow for some more fine-grained info.
Anyone here savvy enough to help me out?
SELECT std.STATUSNAME "Request Status",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 3
Thanks,
Will