This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,779 Users
  • 2,269,776 Discussions
  • 7,916,827 Comments

Discussions

Open a New Tab, Window from Interactive Report Link

Comet
Comet Member Posts: 176 Blue Ribbon
edited Feb 25, 2020 5:16PM in APEX Discussions

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 created a link to the external application to allow the user to open the work order from the report.  The properties for the WORK_ORDER_NUMBER link column are: 

Type: Link

Target Type: URL

Target URL: http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#

Link Text: #WORK_ORDER_NUMBER#

This works okay except that it opens the work order in the same tab and the user cannot navigate back to the APEX application page.  We have a work around which is to right-click the link and select ‘Open in new tab’ or ‘Open in new window’ menu option but this will require additional training and there is no guarantee the users will always remember this.  Right-clicking and selecting either menu option generates a URL as follows:

http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=51799863+target="_blank"

I tried setting the Target URL property to http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#+target="_blank"  but this does not open a new tab or window.  Something to consider is that the system always challenges the user with a Windows Security iexplore dialog to re-enter their credentials (i.e., user name and password).  Could this Windows security dialog be interfering with opening a new page or window.  Is there a way to automatically open a new tab or a new window when the user clicks the work order number link?  If the Windows security dialog is interfering is there a technical work-around?

Tagged:
Sylvain Martel

Best Answer

  • fac586
    fac586 Senior Technical Architect EdinburghMember Posts: 21,579 Red Diamond
    edited Feb 25, 2020 5:12PM Answer ✓
    Comet wrote: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 created a link to the external application to allow the user to open the work order from the report. The properties for the WORK_ORDER_NUMBER link column are: Type: LinkTarget Type: URLTarget URL: http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#Link Text: #WORK_ORDER_NUMBER#This works okay except that it opens the work order in the same tab and the user cannot navigate back to the APEX application page. We have a work around which is to right-click the link and select ‘Open in new tab’ or ‘Open in new window’ menu option but this will require additional training and there is no guarantee the users will always remember this. Right-clicking and selecting either menu option generates a URL as follows:http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=51799863+target="_blank"I tried setting the Target URL property to http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#+target="_blank" but this does not open a new tab or window. Something to consider is that the system always challenges the user with a Windows Security iexplore dialog to re-enter their credentials (i.e., user name and password). Could this Windows security dialog be interfering with opening a new page or window. Is there a way to automatically open a new tab or a new window when the user clicks the work order number link? If the Windows security dialog is interfering is there a technical work-around?

    Set the Link Attributes property to target="_blank".

    Sylvain Martel

Answers

  • fac586
    fac586 Senior Technical Architect EdinburghMember Posts: 21,579 Red Diamond
    edited Feb 25, 2020 5:12PM Answer ✓
    Comet wrote: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 created a link to the external application to allow the user to open the work order from the report. The properties for the WORK_ORDER_NUMBER link column are: Type: LinkTarget Type: URLTarget URL: http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#Link Text: #WORK_ORDER_NUMBER#This works okay except that it opens the work order in the same tab and the user cannot navigate back to the APEX application page. We have a work around which is to right-click the link and select ‘Open in new tab’ or ‘Open in new window’ menu option but this will require additional training and there is no guarantee the users will always remember this. Right-clicking and selecting either menu option generates a URL as follows:http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=51799863+target="_blank"I tried setting the Target URL property to http://appprd:8080/appname/ui/appname.jsp?event=loadapp&value=wotrack&uniqueid=#WORKORDERID#+target="_blank" but this does not open a new tab or window. Something to consider is that the system always challenges the user with a Windows Security iexplore dialog to re-enter their credentials (i.e., user name and password). Could this Windows security dialog be interfering with opening a new page or window. Is there a way to automatically open a new tab or a new window when the user clicks the work order number link? If the Windows security dialog is interfering is there a technical work-around?

    Set the Link Attributes property to target="_blank".

    Sylvain Martel