Need help with a query for a report
I want to run a report that shows the requests completed by a particular group of technicans in the last 60 days. I ran this report that shows requests completed by this group in the last quarter, and the query looks like this:
SELECT ti.FIRST_NAME 'Technician',wo.WORKORDERID 'Request ID',wo.COMPLETEDTIME 'Completed Time',wo.TITLE 'Subject',wo.DESCRIPTION 'Description' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID 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 ((( qd.QUEUENAME = 'Logistics - SeaMobile MPS') AND ((wo.COMPLETEDTIME >= $P{fromdate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND ((wo.COMPLETEDTIME <= $P{todate}) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) AND wot.THD_WOID=wot.WORKORDERID ORDER BY 1
Can anyone help me modify the query so it shows me the requests completed in the last 60 days?
Thanks!
Carolyn
New to ADSelfService Plus?