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:
- Add columns , each column is unique role from predefined list.
- Add row, unique for combination of app, field, field value, role id.
- 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
)
);