Add task title to Query
Hello
how i may add the "Task title" to the below query?
select top 50000 "ti"."FIRST_NAME" AS "Assigned Technician", "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time", "sdo"."NAME" AS "Site", "ct"."TIMESPENT" AS "Time Spent", "rctd"."FIRST_NAME" AS "Time Spent Technician", "ti"."FIRST_NAME" AS "Assigned Technician", "ct"."DESCRIPTION" AS "Time Spent Description" 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 "SiteDefinition" "siteDef" ON "wo"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" 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 (("wo"."TITLE" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%daily activity%') AND ((("wo"."CREATEDTIME" >= 1451595600000) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= 1483217999000) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1))))) AND wo.ISPARENT='1' ORDER BY 1, 2
Thank you
.
how i may add the "Task title" to the below query?
select top 50000 "ti"."FIRST_NAME" AS "Assigned Technician", "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time", "sdo"."NAME" AS "Site", "ct"."TIMESPENT" AS "Time Spent", "rctd"."FIRST_NAME" AS "Time Spent Technician", "ti"."FIRST_NAME" AS "Assigned Technician", "ct"."DESCRIPTION" AS "Time Spent Description" 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 "SiteDefinition" "siteDef" ON "wo"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" 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 (("wo"."TITLE" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%daily activity%') AND ((("wo"."CREATEDTIME" >= 1451595600000) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= 1483217999000) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1))))) AND wo.ISPARENT='1' ORDER BY 1, 2
Thank you
.