Hello, we have a time spent report, but only show the worklogs from workorders.
We want to show also the worklogs from changes and projects.
We have SDP 11.0 and SQL Server.
This is our query now:
SELECT "ct"."TS_ENDTIME" AS "Hora de finalización del tiempo empleado", "wo"."WORKORDERID" AS "ID de la solicitud", "wo"."TITLE" AS "Asunto", "ct"."TS_STARTTIME" AS "Hora de inicio del tiempo empleado", "ct"."TS_ENDTIME" AS "Hora de finalización del tiempo empleado", "ct"."TIMESPENT" AS "Tiempo empleado", "wtd"."NAME" AS "Tipo de registro de trabajo", "rctd"."FIRST_NAME" AS "Técnico del tiempo empleado" 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 "WorkLogTypeDefinition" "wtd" ON "ct"."WORKLOGTYPEID"="wtd"."WORKLOGTYPEID" WHERE ( ( "rctd"."FIRST_NAME" = N'My name here' ) AND ( ( ( "ct"."TS_ENDTIME" >= 1592172000000 ) AND ( ( "ct"."TS_ENDTIME" != 0 ) AND ( "ct"."TS_ENDTIME" IS NOT NULL ) ) ) AND ( ( "ct"."TS_ENDTIME" <= 1592776799000 ) AND ( ( ( "ct"."TS_ENDTIME" != 0 ) AND ( "ct"."TS_ENDTIME" IS NOT NULL ) ) AND ( "ct"."TS_ENDTIME" != -1 ) ) ) ) ) AND wo.ISPARENT='1' ORDER BY 1, 2