20211204 - Interactive Grid 더블 클릭해서 새로운 윈도우 창 열기

1. Dynamic Action

Name : DoubleClick_POMSTIG

When - Event : Double Click

Selection Type : Region

var ig$             = apex.region("myStaticIGPOMST").widget();

var grid            = ig$.interactiveGrid("getViews","grid");

var model           = grid.model;

var selectedRecords = grid.view$.grid("getSelectedRecords");

var record1         = selectedRecords[0];

var l_url = 'f?p=#APP_ID#:9:#SESSION#::NO:RP,9:P9_PO_ID:#POID#';

l_url = l_url.replace('#APP_ID#',  $v('pFlowId'));

l_url = l_url.replace('#SESSION#', $v('pInstance'));

l_url = l_url.replace('#POID#',    model.getValue(record1, "PO_ID"));

// execute PL/SQL API apex_uti.prepare_url to generate a valid Session State Protection checksum

apex.server.process(

    'BTN-popup',

    {x01: l_url},

    {success: function (pData) {

            apex.navigation.openInNewWindow(pData);

        },

        dataType: "text"

    }

);

2. Ajax Callback

Name : BTN-popup

Type : Execute Code

Source - Location : Local Database

Language : PL/SQL

PL/SQL Code

declare

    l_url    varchar2(2000);   

    l_result varchar2(4000);

begin

    l_result := apex_util.prepare_url(apex_application.g_x01);

    htp.prn(l_result);

end;

참고

https://docs.oracle.com/en/database/oracle/application-express/21.2/aexjs/apex.navigation.html#.openInNewWindow