Add notes field to existing Reports.
I would like to add the notes field to several reports that we currently have, but Notes (DiscussionNotes) is not an available choice. Is there a way to get that field added? Here is an example of the query for one of the reports: The DB is MS SqlServer
SELECT "wo"."WORKORDERID" AS "Request ID", "rtdef"."NAME" AS "Request Type", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS "Description", "wo"."COMPLETEDTIME" AS "Completed Time", "std"."STATUSNAME" AS "Request Status", "wof"."UDF_CHAR11" AS "Project State", "ci"."CINAME" AS "Asset Name", "qd"."QUEUENAME" AS "Group", "aau"."FIRST_NAME" AS "Requester", "ti"."FIRST_NAME" AS "Technician", "wof"."UDF_CHAR15" AS "IT Work Queue", "wo"."RESOLVEDTIME" AS "Resolved Time" FROM "WorkOrder" "wo" LEFT JOIN "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID" LEFT JOIN "CI" "ci" ON "wo"."CIID"="ci"."CIID" 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 "RequestTypeDefinition" "rtdef" ON "wos"."REQUESTTYPEID"="rtdef"."REQUESTTYPEID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" LEFT JOIN "WorkOrder_Queue" "woq" ON "wo"."WORKORDERID"="woq"."WORKORDERID" LEFT JOIN "QueueDefinition" "qd" ON "woq"."QUEUEID"="qd"."QUEUEID" LEFT JOIN "WorkOrder_Fields" "wof" ON "wo"."WORKORDERID"="wof"."WORKORDERID" WHERE (((("rtdef"."NAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Incident') AND ((((("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Canceled') AND ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Development')) AND ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Onhold')) AND ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Open')) OR ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS IS NULL))) AND ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'IT Data Warehouse')) AND ((("wo"."COMPLETEDTIME" >= datetolong('1475294400000') AND (("wo"."COMPLETEDTIME" != 0) AND ("wo"."COMPLETEDTIME" IS NOT NULL))) AND (("wo"."COMPLETEDTIME" <= datetolong('1491537599000') AND ((("wo"."COMPLETEDTIME" != 0) AND ("wo"."COMPLETEDTIME" IS NOT NULL)) AND ("wo"."COMPLETEDTIME" != -1))))) AND wo.ISPARENT='1'
Any help would be great.
Thank you
New to ADSelfService Plus?