Home/ Questions/Q 2249
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-10-11T16:09:21+00:00

Dynamic Action Redirect To Another Page in Oracle Apex

  • 0
  • 0

Dear Sir How Can I Redirect To Page By Dynamic Action.

FOR example i have Page item :P2_CODE and  value from application Items and some values from Substitution String then combine all like

 &REP_URL.&REPORT=&REP_DIR.Invoice.rep&PRM_CODE=&GLB_CODE.&PRM_NUM=&P2_CODE.

and this all i want pass page no 3 there is page item :P3_VALUE how to do this sir  i dont want to do it by Branches only i want by DA.

apexlinkpage
Share
Leave an answer

Leave an answer

Browse

3 Answers

  1. You can create any DA to execute JavaScript code. Below is the JavaScript code example to redirect to the specific page:

    javascript:window.open('f?p=&APP_ID.:1:&APP_SESSION.:::1', '_self');

    The URL format is the common Oracle Apex URL format.

  2. Dear Sir Page 3 is Modal dialog page and there is one page item name :P3_CODE in

    i want pass from Page 2 this &REP_URL.&REPORT=&REP_DIR.Invoice.rep&PRM_CODE=&GLB_CODE.&PRM_NUM=&P2_CODE.

    this all will go to p3 page item not in URL

  3. step 1–
    create a dynamic action for open modal dialog

    var x="test"; // replace this x variable to your required passing value
var url ="f?p=#APP_ID#:2:#SESSION#::NO:RP,2:P2_CODE :#P_ITEM#";
url = url.replace("#APP_ID#", $v("pFlowId"));
url = url.replace("#SESSION#", $v("pInstance"));
url = url.replace("#P_ITEM#",x); //--
apex.server.process("PREPARE_URL", {x01: url},{
success: function(pData){
if (pData.success === true){
apex.navigation.redirect(pData.url);
}else{
console.log("inside false cond");
}
},
error: function(request,status,error){
console.log("status---"+status+" error----"+error);
}
});

    step2—
    create ajax callback process == process name==> “PREPARE_URL”
    write following pl/sql code

    declare
result varchar2(23333);
begin
result:=apex_util.prepare_url(apex_application.g_x01);
apex_json.open_object;
apex_json.write('success', true);
apex_json.write('url', result);
apex_json.close_object;
exception
when others then
apex_json.open_object;
apex_json.write('success', false);
apex_json.write('message', sqlerrm);
apex_json.close_object;
end;