I use this query in SD, that shows technician time grouped by date but it only shows worklogs for the request module.   Can you modify so that;

1) Ability to change Technician name in query

2) Add Project worklog time in details (not summed) to same query using same fields -- project id could be in place of ticket number

3) Ability to change dates in query

Thank you.

SELECT ct.TS_ENDTIME "Time Spent Endtime",wo.WORKORDERID "Request ID",wo.TITLE "Subject",rctd.FIRST_NAME "Time Spent Technician",dpt.DEPTNAME "Department",std.STATUSNAME "Request Status",ct.TIMESPENT "Time Spent" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE  ((rctd.FIRST_NAME = N'Ellen DelGreco' COLLATE SQL_Latin1_General_CP1_CI_AS) AND (((ct.CREATEDTIME >= datetolong('2015-12-01') AND ((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL))) AND ((ct.CREATEDTIME <= 1483246799000) AND (((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL)) AND (ct.CREATEDTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1