1. Overview
This document will be helpful in protecting updation on a row based condition in Oracle apex interactive Grid.
2. Technologies and Tools Used
- Oracle Apex code.
3. Use Case
In a transaction table when a status column is updated as “completed” then the corresponding row should not be allowed to update or delete.
4. Architecture
We can achieve this by using below method.
Code:
Select
tran_id ,
product ,
qty ,
issued_qty ,
status ,
case when status=’Completed’ then ” else ‘UD’ end Readonly_col
from
transaction
Step 1:
Set Readonly_col as Hidden column
Step 2:
Enable Query only option in Readonly_col column Source.
Step 3:
Set Allowed Row Operations Column to Readonly_col Under Interactive Report Attributes –> EDIT.
5. Screen Shot
Output:
Recent Posts