Oracle Apex: Opening a URL in a new window, from an interactive report

on

Problem

You have a link which opens up a URL to an external site, but each time you click on it, it replaces your window, and you lose your session.

Solution

Use the link attribute to add the link attribute.
There are lots of people talking about the "target="_blank" method, but nobody (that I saw) describing how this would work in an interactive report.

In the query you have your URL

select 'www.google.com' url from dual


Nothing new with the link, but the link attribute is key.

target="_blank"

Acknowledgment

Thanks to Theo: https://www.linkedin.com/in/papadakistheo


Comments

  1. Unknown3 May 2017 at 15:46

    OMG -This works perfect. So much BS on this topic on Google, you are the only one with the correct answer THANKS!!!!

    ReplyDelete
  2. Anonymous9 June 2018 at 08:42

    i spent so much time searching how to do this and this solution worked great. Even after all this time and prob several versions later.
    Thank you

    ReplyDelete
  3. Anonymous9 April 2020 at 11:09

    Yes... Big thanks. This is a way better approach than the Javascript version people are referencing on other sites. I was having lots of issues using the JS version. This is cleaner and works way better. Thanks again.

    ReplyDelete
  4. Anonymous23 August 2020 at 02:21

    Also use this process:

    Go to Column
    Column Type : link
    Target : URL
    javascript:window.open('f?p=&APP_ID.:1:&SESSION.::NO:1:P1_PID:'+$v("P2_PID")+'');

    ReplyDelete
  5. Anonymous24 January 2023 at 14:42

    Gracias me ayudo mucho

    ReplyDelete
  6. Anonymous12 July 2023 at 11:59

    FINALLY! Thank you..

    ReplyDelete

Post a Comment