I’m working with an Oracle APEX application that handles a large volume of data. To manage this, I’ve set the page size to 5 and configured the grid to display only 5 records at a time with a fixed report height of 270px.
Problem
When I try to select a newly created row on dialog close, the following code does not fetch records beyond the initial 20 (since only 20 records are loaded initially):
// Code on Dialog Close
var record = apex.region("employees_grid").widget().interactiveGrid("getViews", "grid").model.getRecord("78");
apex.region("employees_grid").widget().interactiveGrid("getViews", "grid").setSelectedRecords([record], true);
// Initialization JavaScript Function
function(config) {
config.defaultGridViewOptions = {
selectionStateItem: "P2_SELECTED_EMPNOS"
};
config.defaultModelOptions = {
pageSize: 5
};
return config;
}
Issue
The above code is unable to fetch records beyond the initial 20 loaded records. How can I modify this to dynamically select the newly created row, even if it falls outside the initially loaded records?