Query enrichment with Notes field

Query enrichment with Notes field

Hi eveyone,

I have the following query & I would like to add the "Notes" field.
For each Service Request there might be more than one notes. I need to have them all exported in the final report.


SELECT "rctd"."FIRST_NAME" AS "Time Spent Technician", "wof"."UDF_CHAR1" AS "Service Request Type", "wo"."WORKORDERID" AS "Request ID", "wof"."UDF_DATE1" AS "Assigned Date", "ct"."TIMESPENT" AS "Time Spent", "aau"."FIRST_NAME" AS "Requester", "wo"."TITLE" AS "Subject", "wof"."UDF_CHAR8" AS "Requesters Site", "std"."STATUSNAME" AS "Request Status", "qd"."QUEUENAME" AS "Group", "ti"."FIRST_NAME" AS "Assigned Technician", "ct"."CREATEDTIME" AS "Time Spent Created Time", "rctd"."FIRST_NAME" AS "Time Spent Technician", "wo"."COMPLETEDTIME" AS "Completed Time", "ct"."TOTAL_CHARGE" AS "Time Spent Total_Charge", "wof"."UDF_CHAR9" AS "ACF / e-PSD / SR#"  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 "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" 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" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" LEFT JOIN "WorkOrder_Fields" "wof" ON "wo"."WORKORDERID"="wof"."WORKORDERID" WHERE  (((("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'IS/OPS&PO/FUJITSU') AND ((("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Closed') OR ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Resolved')) OR ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Resolved by Technician'))) AND (((("wof"."UDF_CHAR1" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Major Project') OR ("wof"."UDF_CHAR1" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Mini Project')) OR ("wof"."UDF_CHAR1" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Request Internal')) OR ("wof"."UDF_CHAR1" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Request Shops'))) AND ((("wo"."COMPLETEDTIME" >= 1488319200000) AND (("wo"."COMPLETEDTIME" != 0) AND ("wo"."COMPLETEDTIME" IS NOT NULL))) AND (("wo"."COMPLETEDTIME" <= 1490993999000) AND ((("wo"."COMPLETEDTIME" != 0) AND ("wo"."COMPLETEDTIME" IS NOT NULL)) AND ("wo"."COMPLETEDTIME" != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1



BR,
MaryP
              New to ADManager Plus?

                New to ADSelfService Plus?