Report request please
Hi there,
I have an existing report that I would like modified and the person who wrote it has left the company. I don't have the knowledge to use the query editor to edit it and I need information additional to that available from custom reports. Please could someone urgently help me?
It can be based on this report (screenshot also attached) but requires a lot of additions:
SELECT std.STATUSNAME "Request Status",ti.FIRST_NAME "Technician",ti.FIRST_NAME "Technician" FROM WorkOrder wo 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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((wo.CREATEDTIME >= 1328486400000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1329091199000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))) AND wo.ISPARENT=1
1. I would like to show only Technicians where 'login is enabled' in other words those who still work with us!
2. I would like under each Technician to have the data broken down by Category as well
3. The report is currently scheduled every week to show requests received in the last week. I would like it instead to show *all* requests, but also break the data down into requests received within last 30 days, requests received within last 7 days and requests received within last 48 hours.
I appreciate that this is a big report but if you could please help that would be great!
Many thanks, Angela
I have an existing report that I would like modified and the person who wrote it has left the company. I don't have the knowledge to use the query editor to edit it and I need information additional to that available from custom reports. Please could someone urgently help me?
It can be based on this report (screenshot also attached) but requires a lot of additions:
SELECT std.STATUSNAME "Request Status",ti.FIRST_NAME "Technician",ti.FIRST_NAME "Technician" FROM WorkOrder wo 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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((wo.CREATEDTIME >= 1328486400000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1329091199000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))) AND wo.ISPARENT=1
1. I would like to show only Technicians where 'login is enabled' in other words those who still work with us!
2. I would like under each Technician to have the data broken down by Category as well
3. The report is currently scheduled every week to show requests received in the last week. I would like it instead to show *all* requests, but also break the data down into requests received within last 30 days, requests received within last 7 days and requests received within last 48 hours.
I appreciate that this is a big report but if you could please help that would be great!
Many thanks, Angela