Skip to Main Content
Feature Request FR-4375
Product Area Page Components
Status OPEN

2 Voters

OLD and NEW specifiers for IG columns

nikhil.aragonda2 Public
· Mar 27 2025

Idea Summary
Currently there is no way to use the OLD or NEW specifiers on column level validations of an IG

We need to have such a feature in APEX so that the validations can be written more easily at the column level 

Use Case
Sometimes the OLD value of a cell needs to be compared with the new value of the cell in the IG and execute certain validations based on the OLD values

This is currently not possible . We obviously need to use a trigger and raise custom error message.

The problem with triggers is the concerned cell will not be highlighted with a red border. 

When the IG has lot of columns and rows pinpointing the error cell and the ability to navigate to the particular cell is a very sort after feature.

With the DB trigger raising exception only the row is marked but end users doesn't know which cell is of the concern from the error message.

Preferred Solution (Optional)
Provide a way in apex PL/SQL validations to access the current cells old and new values in the IG

for example :column_name.old and :column_name.new

This idea is open.