Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Correlation between data and rowid in Interactive Grid

Jeremy WebbMar 2 2018

Hi,

I am trying to find out where in the interactive model, or somewhere else, that the correlation is held between the IG rowid and the actual data values.

For example, I have an interactive grid which has a number of columns on, say

NAME, JOB, DEPT

If I am selecting a row then I just create a dynamic action which knows which row was clicked on, and gets the data-id for the nearest TR based in this.triggeringElement. That works great.

However I have a senario where I need to update the IG based on another action, not a click on a specific row.

I have found a way to do this when the unique key is displayed, as I can then search of that and again find the data-id of the nearest TR. Again works great.

But where this fails is when the unique key is not displayed but is hidden. It still exists within the IG model but does not exist in the DOM. So how do I now get the IG rowid. I thought within the model there would be some sort of correlation between rowid and the rows so I could say something like,

find the unique key within the data, and tell me which IG rowid this appears on. But I have scoured the IG model and cannot find this anywhere.

Is anyone able to point me to where this is held?

This is on Apex 5.1.1, soon moving to 5.1.4.

Any help greatly appreciated.

Thanks,

Jeremy

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2018
Added on Mar 2 2018
0 comments
179 views