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!

Interactive Grid JS API ISSUE

Abdullah Sharhan3 hours ago — edited 3 hours ago
apex.server.process(
 "GET_ITEMS_JSON",
 { pageItems: "#P42_MPI_ID" },
 {
   dataType: "json",
   success: function (data) {
     if (data && data.length && data[0].error) {
       apex.message.alert(data[0].error);
       return;
     }
     var region = apex.region("DWM_INFO");
     var widget = region.widget();
     var grid = widget.interactiveGrid("getViews", "grid");
     var model = grid.model;
     data.forEach(function (r) {
       console.log(r);
       var recId = model.insertNewRecord();
       var rec = model.getRecord(recId);
       
       model.setValue(rec, "ITEM_ID", r.ITEM_ID);
       // model.setValue(rec, "ITEM_UNIT", r.ITEM_UNIT);
       // model.setValue(rec, "QUANTITY", r.QUANTITY);
     });
   },
   error: function (xhr, status, err) {
     apex.message.alert("Load failed: " + err);
   }
 }
);

why after setting the value and save, all I see in the database is null values?

This post has been answered by Karel Ekema on Feb 28 2026
Jump to Answer
Comments
Post Details
Added 3 hours ago
2 comments
24 views