Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF table with dynamic columns

Somesh Kumar-OracleJun 23 2025 — edited Jun 23 2025

Hi Experts,

Please advice how to achieve this UX ***Moderator action: removed link to external page as it's considered spam *** in ADF, my database table to store values looks like below:
functionality needed:

  1. Add columns , each column is unique role from predefined list.
  2. Add row, unique for combination of app, field, field value, role id.
  3. highlight Roles cell with changed activation/disabled status, added roles, added rows etc.

I already achieved it with brute force of 150 max transient variables in my VO which works on complicated pivot query, but many issues / incomplete functionality hitting too many roadblocks; i want advice on how to proceed and change approach so UX and required features.

CREATE TABLE ROLE_MATRIX_DETAIL (
   RM_DETAIL_ID          NUMBER(19)     NOT NULL,
   RM_ID                 NUMBER(19)     NOT NULL,
   RM_VERSION            INTEGER         NOT NULL,
   APP_ID                NUMBER(19)     NOT NULL,
   APP_NAME              VARCHAR2(3000),
   FIELD_KEY             NUMBER(19)     NOT NULL,
   FIELD_LABEL           VARCHAR2(3000),
   FIELD_VALUE           VARCHAR2(3000),
   ROLE_ID               NUMBER(19)     NOT NULL,
   ROLE_NAME             VARCHAR2(3000),
   ROLE_VALUE            CHAR(1) DEFAULT 'N',
   ROLE_ROLETYPE         VARCHAR2(64),
   ROLE_ROLECATEGORY     VARCHAR2(64),
   OLD_FIELD_VALUE       VARCHAR2(3000),
   CONSTRAINT PK_ROLE_MATRIX_DETAIL PRIMARY KEY (RM_DETAIL_ID),
   CONSTRAINT FK_ROLE_MATRIX_DETAIL_TO_MATRIX FOREIGN KEY (RM_ID, RM_VERSION)
       REFERENCES ROLE_MATRIX (RM_ID, RM_VERSION)
       ON DELETE CASCADE
       ENABLE VALIDATE,
   CONSTRAINT UQ_RMD_RM_ID_VERSION UNIQUE (RM_ID, RM_VERSION),
   CONSTRAINT UQ_RMD_FIELDS_COMBO UNIQUE (
       RM_ID, RM_VERSION, APP_ID, FIELD_KEY, FIELD_VALUE, ROLE_ID
   )
);
Comments
Post Details
Added on Jun 23 2025
4 comments
165 views