I have created a report (Attached) and need to append to the end of this report (the last column) any tickets that are linked to the ticket in that row and have them be hyperlinks exactley like column D.

 

Can you please provide a modified query to the below that will accomplish that?

 

 

SELECT dpt.DEPTNAME "Department",aau.FIRST_NAME "Requester",wo.WORKORDERID "Request ID",icd.NAME "Item",wo.TITLE "Subject",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wof.UDF_LONG1 "Hours Estimate" 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 WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID 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_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  ((qd.QUEUENAME = N'Web Applications' COLLATE SQL_Latin1_General_CP1_CI_AS) AND (((((std.STATUSNAME != N'Closed' COLLATE SQL_Latin1_General_CP1_CS_AS) AND (std.STATUSNAME != N'Open' COLLATE SQL_Latin1_General_CP1_CS_AS)) AND (std.STATUSNAME != N'Resolved' COLLATE SQL_Latin1_General_CP1_CS_AS)) AND (std.STATUSNAME != N'Waiting For Customer' COLLATE SQL_Latin1_General_CP1_CS_AS)) OR (std.STATUSNAME IS NULL)))  AND wo.ISPARENT=1