BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Oracle / Apex / Oracle Apex: Open multi dialog page from classic report.

Oracle Apex: Open multi dialog page from classic report.

Asalamo Alikom ..

I have a classic report like department list
and i want to link a report column with multiple modal page and its depend on every single department.
Like when i click on ‘IT’ department then open a modal page and when i click on ‘Sales’ department then open different modal page. I need this solution!
Regards..

Steps..
1- create spicial modal page for every department (It, Sales, …).
2- create new column into department table is “dept_modalPageId”
3- create modal page for sales and emp and insert page id  into dept_modalPageId column .
4- put dept_modalPageId value = <Dialog page id>
5- create function ..

6- classic report regin is ..

Screenshot from 2016-08-08 16:01:57

7- on DIALOGPAGE column (HTML Expression)put this code to handling button to fire dialog page..

Screenshot from 2016-08-08 16:02:29 Screenshot from 2016-08-08 16:02:51

You can see sample @
https://apex.oracle.com/pls/apex/f?p=78167:5
User: help
Pass: help

Try press on “Click me” button into sales and emp row.

I like OracleApex..

About Amr

Check Also

Oracle Apex: Speed up your APEX

Sometimes i find my Apex is so slow when saving changes after development into Design ...

Oracle Apex API “$s()”

The Apex JavaScript API has some very convenient functions to access the values of page ...