Hi. I am using Oracle APEX 22.1.1.
I have 2 IG's. I am grabbing data from region 1 and inserting it into region 2. I am using "getSelectedRecords[index of the record][index of the column] to grab a specific value i.e a column named "PATIENT_NAME". There will be a problem when columns order changes. For example, the grid has PATIENT_ID which is the first column displayed to the user and PATIENT_NAME which is displayed after PATIENT_ID. If the user changes the order and displayed PATIENT_NAME before PATIENT_ID, the code will grab a wrong value. How to solve that? How to reference the name instead of the index number?
I remember there was an option "recordIsArray" that determines if the model should return an array or an object, but I can not find it anymore, and I do not know how to set it. Is that the way I should use or is there a better way?