I have built out a proof of concept interactive grid where we allow users to edit data in configuration tables. I'm utilizing the plsql return function query source and am renaming and sorting the columns on the fly with jQuery. I have pretty much accounted for everything however, when I execute the jQuery, the APEX$ROW_ACTION (hamburger menu column) disappears and I cannot seem to keep it once the jQuery fires. Anyone have a solution?
We are running APEX 20.2
This is what I am firing after the page loads. It is generated by PL/SQL via AJAX call.
$(document).ready(function () {
var Grid_1 = apex.region("aaGridEdit").widget().interactiveGrid("getViews").grid;
Grid_1.view$.grid({
"editable": true,
"columns": [{
"VC1": {
"heading": "Batch Mask",
"seq": 1
},
"VC2": {
"heading": "Autobatch Method",
"seq": 2
},
"VC3": {
"heading": "Descr",
"seq": 3
},
"VC4": {
"heading": "User Id",
"seq": 4
},
"LOV1": {
"heading": "Setofbooks",
"seq": 5
},
"LOV2": {
"heading": "Auto Close",
"seq": 6
},
"LOV3": {
"heading": "Auto Settle",
"seq": 7
},
"VC5": {
"heading": "Email Address",
"seq": 8
},
"LOV4": {
"heading": "Batch Type",
"seq": 9
}
}
]
});
Grid_1.view$.grid("refreshColumns").grid("refresh");
});