Disable Hyperlinks just on Reports
Hi Adventnet,
Been trying to disable hyperlinks when creating reports, were posting these reports daily, but want to disable the hyperlinks so that users cannot access the tickets.
query of report:
SELECT std.STATUSNAME 'Request Status',wo.WORKORDERID 'Request ID',wo.TITLE 'Subject',aau.FIRST_NAME 'Requester',wo.CREATEDTIME 'Created Time',wo.DUEBYTIME 'Dueby Time',ti.FIRST_NAME 'Technician',std.STATUSNAME 'Request Status' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 1
Been trying to disable hyperlinks when creating reports, were posting these reports daily, but want to disable the hyperlinks so that users cannot access the tickets.
query of report:
SELECT std.STATUSNAME 'Request Status',wo.WORKORDERID 'Request ID',wo.TITLE 'Subject',aau.FIRST_NAME 'Requester',wo.CREATEDTIME 'Created Time',wo.DUEBYTIME 'Dueby Time',ti.FIRST_NAME 'Technician',std.STATUSNAME 'Request Status' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_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 LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (wot.THD_WOID=wot.WORKORDERID) ORDER BY 1