Tuesday, 12 December 2017

Interactive grid validation

APEX and IG validation


Interactive grid validation

Check for duplicates

Something that come out today as a question - How to validate Interactive grid to check if your user typed primary key like EMPNO is not already in the table?  

Catch was to do this only on insert as people will not be able to delete or update it afterwards.

Adding a validation to your IG is easy enough, creating one as:

Where PLSQL Function body code is:

That is all. Notice the use of APEX$ROW_STATUS to detect if row is created.

Happy APEXing,


  1. Thank you this was helpfull

  2. If a user select two duplicates values without saving it does not work???

  3. Is there a way to use APEX_$ROW_STATUS is JS? If the row status is update I need to set the values of WHO_UPDATED column, if the status is create I need to set the value of WHO_CREATED column.