I created a page in APEX 5.1.2 with an interactive report of work orders. Two of the columns in the report are named WORK_ORDER_NUMBER and WORKORDERID. WORK_ORDER_NUMBER is the clerical reference number and WORKORDERID is a code used by an external third-party enterprise application. I need to create a link to the external application to allow the user to open the work order from the report. I have a URL to the external application as follows:
http://abcprd:7090/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=51780624
(I disguised the URL for security reasons but I think this all of the information you need.) The number 51780624 is a particular uniqueid and I need to be able to select the work order # on the report and pass WORKORDERID to the URL.
I defined the interactive report WORKORDERID as Type Link. In the link properties section I set the Target Type as URL and entered the URL above. The Link Text property I set to one of the pencil icons since the user doesn’t need to see the workorderid? What do I replace 51780624 with and what do I set the Link Attributes property with? Ideally I would like to make the WORK_ORDER_NUMBER the link and hide WORKORDERID column. How would I define the link and how could I set the value in the URL to the WORKORDERID.