I would like to add the newest/latest discussion note to a report.  Below is the query for the existing report.  Any ideas?

Thanks

SELECT "dpt"."DEPTNAME" AS "Department", "wo"."CREATEDTIME" AS "Created Time", "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS "Description", "pd"."PRIORITYNAME" AS "Priority", "std"."STATUSNAME" AS "Request Status", "rtdef"."NAME" AS "Request Type"  FROM "WorkOrder" "wo" LEFT JOIN "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" LEFT JOIN "DepartmentDefinition" "dpt" ON "wo"."DEPTID"="dpt"."DEPTID" LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "RequestTypeDefinition" "rtdef" ON "wos"."REQUESTTYPEID"="rtdef"."REQUESTTYPEID" LEFT JOIN "PriorityDefinition" "pd" ON "wos"."PRIORITYID"="pd"."PRIORITYID" 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  ((("wof"."UDF_CHAR26" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Workforce Management') AND (((("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Closed') AND ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Completed')) AND ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Resolved')) OR ("std"."STATUSNAME" COLLATE SQL_Latin1_General_CP1_CS_AS IS NULL))) AND (((((("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'API Group') OR ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Application Development')) OR ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Application Services')) OR ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Business Process Team')) OR ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Project Review Team')) OR ("qd"."QUEUENAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Tigers')))  AND wo.ISPARENT='1'  ORDER BY 1, 7