Skip to main content

Open modal/inline dialog in Oracle APEX using JS

Analysis:

From Oracle Apex 4.2, Inline dialog can be opened as modal dialog/popup using JS.

Open inline dialog region as modal dialog:

Step 1: Create static region.

Step 2: Set Template => Inline Dialog.

Step 3: Assign the static id to the region.


Fig 1: Set template and Static ID

Step 4: Create button or change one of the report column type to Link. (Action: Redirect URL).

Step 5: Put the below JS to open the region as modal dialog.

               javascript:openModal('unitpricedetails');


           Fig 2: Open simple modal dialog




Open inline dialog region as modal dialog and pass values to the items:


Common Steps: Step 1 to Step 4.

Step 5: To pass value to that region, create P1_UNIT_ID in the inline dialog.


      javascript:$s('P1_UNIT_ID','#UNIT_ID#');javascript:openModal('unitpricedetails');



Fig 3: Open simple modal dialog and assign the values

To open inline dialog as modal dialog and show report data (Link from Classical  or Interactive Report):

Common Steps: Step 1 to Step 4.

Step 5: To show report in that region. Create static classical report and set template as inline dialog.

javascript:$s('P1_UNIT_ID','#UNIT_ID#');javascript:openModal('unitpricedetails'); $("#unitpricedetails").trigger("apexrefresh");


Fig 4: Show report (Link from Classical ore Interactive Report)


To open inline dialog region as modal dialog and show report data (Link from Interactive Grid):

Common Steps: Step 1 to Step 4.

Step 5: To show report in that regionCreate static classical report and set template as inline dialog.

javascript:$s('P1_UNIT_ID','&UNIT_ID.');javascript:openModal('unitpricedetails'); $("#unitpricedetails").trigger("apexrefresh");


Fig 5: Show report (Link from Interactive Grid)


Output:


Fig 6: Output (Link from Interactive Grid)


Comments

  1. THANKS A TON!!!!

    Saved me loads of heartburn and time!!

    ReplyDelete

Post a Comment

Popular posts from this blog

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT  *     FROM   ( SELECT  emp . empno ,                emp . ename ,                emp . JOB ,                dept . dname department ,                dept . loc  LOCATION ,                mgr . ename  ...