Skip to Main Content
Feature Request FR-3358
Product Area Page Components
Status CLOSED

3 Voters

Provide an option to refer the column of other interactive grid

mihirpatel749 Public · Sep 13 2023

Idea Summary
Provide an option to refer the column of other interactive grid

Use Case
When we work with master detail interactive grid like department as an parent ig and emp as detail ig, we can't access column of parent ig in the detail ig. 

Preferred Solution (Optional)
can be provided an option something like :DEPT.DEPTNO

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • vincent morneau Admin OP 1.5 years ago

    Hi @mihirpatel749 ,

    This is already possible by designing your SQL queries to contain the columns you want to reference in the detail IG. If I'm missing something, let us know with a link to a test application.

  • mihirpatel749 OP 1.5 years ago

    Hi Vincent,

    Thanks for your reply. 

    I have created a very simple scenario just for understanding purpose. I know that there are ways to do it by using javascript but it becomes more easier when we can refer to master ig's column.

    In the page, I kept 2 master and detail igs for cedants and brokers respectively. I need to calculate broker premium based on cedant's premium and brokerage %. If there is a way to refer master ig's column, I can easialy calculate it by using dynamic action as below,

    :BROKER_PREMIUM := :CEDANTS.CEDANT_PREMIUM * (:BROKER_SHARE/100);

    Please visit below page for more clarity,

    user id/password : MIHIR/MIHIR

    https://apex.oracle.com/pls/apex/r/mihir_ptl1/all-examples-and-demos/home

  • mihirpatel749 OP 1.5 years ago

    @vincent morneau Hi Vincent,

    Thanks for your reply. 

    I have created a very simple scenario just for understanding purpose. I know that there are ways to do it by using javascript but it becomes more easier when we can refer to master ig's column.

    In the page, I kept 2 master and detail igs for cedants and brokers respectively. I need to calculate broker premium based on cedant's premium and brokerage %. If there is a way to refer master ig's column, I can easialy calculate it by using dynamic action as below,

    :BROKER_PREMIUM := :CEDANTS.CEDANT_PREMIUM * (:BROKER_SHARE/100);

    Please visit below page for more clarity,

    user id/password : MIHIR/MIHIR

    https://apex.oracle.com/pls/apex/r/mihir_ptl1/all-examples-and-demos/home

  • jkerr OP 1.5 years ago

    Access to data in a Master, Detail, or any IG from dynamic actions, processes, etc. using PL/SQL (from menu items and referring between IGs) is needed similar to the access provided by Insum's plugin is needed: GitHub - ainielse/get_ig_data  If there is a way to achieve that with SQL please provide an example.