My environment is: Oracle APEX version 21.3.2 running on top of Oracle Database version 19.0.0
I have a Form type of (Interactive Report + Form) that the users do not like so I am trying to mimic how it looks in Oracle ADF by going to another Form type: Interactive Grid. This one keeps everything on the SAME page vs have 2 pages in the IR + Form.
My issue is when using an IG I have a grid of all rows, how do I capture the current (some might use the word “old”) value of a column? In this case I need to access the current value of a column that is of “Select List” type? So that when the user changes the LoV to another value, then I can have validation fire to see if this change is allowed per the business rules.
With the IR + Form, it was easy as I'm calling a new page based on the row clicked on so I can easily submit to page via passing the parameters.
But since I have to use IG (and by the way this data is all in Oracle apex_collections table), I can't see a way to do this. Will this involve JavaScript?
One column is a select list type LoV, the other is textarea (CLOB) type field.
Thank,s