Enable disable records for each row in Interactive report oracle

user_4427508 0
Viewed 212

I have a interactive grid and one item p11_active_yn , based on the item value i want to check this condition for each row , in one grid we may have so many records, the enable disable should check and do for each row in interactive grid,, how to achieve this

interactive-grid oracle-apex oracle11g oracle10g oracle
1 Answers

Check the "Allowed Row Operations" attribute of the Interactive Grid. That feature meets your requirement. The help text is pretty clear.

Let me give an example:

This is on the EMP/DEPT sample dataset. There is page item P72_JOB. Only for the selected job, the record is editable.

Source Query:

select EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO,
       CASE JOB WHEN :P72_JOB THEN 'U' ELSE NULL END AS UPDATE_ALLOWED
  from EMP

Items to submit: P72_JOB

IG Attribute: Allowed Row Operations column: UPDATE_ALLOWED

For the test I added a dynamic action on P72_JOB to refresh the interactive grid on change. Now the interactive grid only allows the rows to be edited for the selected job.

user_41898140
Related