Apex version 24.2.5
Database: 23ai
Hello,
I am currently trying to make an Apex application where I have a master-detail consisting of two Interactive Grids with each using a REST Data Source.
For testing purposes I created two ORDS modules and a REST Data Source for each of them:
- One based on the standard EMP table (master)
- One based on a simple table EMP_ACCESS_GROUPS (detail)
The detail REST Data Source has a parameter empno that should be populated with empno from the selected master row. I configured the parameter to use the Parent Column option. This works correctly for the Fetch Rows operation; however, when I try to Insert or Delete in the detail grid, the parameter value is NULL. I tried using a page item and a dynamic action to set it to the selected master row’s empno, but if I edit a detail row, then select a different master row before saving, the parameter is set to the newly selected empno instead of the original one.
The question is then:
Why does the Parent Column value get set for fetching rows but not for insert/delete operations? Is there some other way to set the detail's parameter value to a column value in the master?
Best Regards,
M. Hansen
----- Definitions-----
Definiton of EMP_ACCESS_GROUPS:
CREATE TABLE "EMP_ACCESS_GROUPS"
( "ACCESS_GROUP_ID" NUMBER,
"EMPNO" NUMBER,
"ACCESS_GROUP_DESC" VARCHAR2(512),
PRIMARY KEY ("ACCESS_GROUP_ID", "EMPNO")
USING INDEX ENABLE
) ;
ALTER TABLE "EMP_ACCESS_GROUPS" ADD CONSTRAINT "EMP_ACCESS_GROUPS_CON" FOREIGN KEY ("EMPNO")
REFERENCES "EMP" ("EMPNO") ON DELETE CASCADE ENABLE;
Definition of the REST Data Source used in the master grid:
With data profile:
Definition of the REST Data Source used in the details grid:
With data profile:
