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!

Get an IG column value

Carlos InglezJan 4 2021

Hello.
I have an Interactive Grid named XXX_LOCAIS, and it is not editable. Just 1 row can be selected at a time.
I need to get a column value as I navigate through the IG records. Ex.: I want to load the value of the column "NAME" as I navigate to a field (Ex. :P100_CURRENT_NAME).
What is the best way to do this? I've tried a Dynamic Action like this:
Selection Change
Region

Execute Javascript code:

var view$ = apex.region("IG_STATIC_NAME").call("getViews", "grid");
var record = view$.grid("getSelectedRecords") [0];
apex.item("My_item_for_field1").setValue(view$.model.getValue(record, "FIELD1");

Does not work

Thanks in advance

This post has been answered by Awais Majeed on Jan 5 2021
Jump to Answer
Comments
Post Details
Added on Jan 4 2021
1 comment
6,203 views