I have this apex form consisting of records being updated by clicking a button which executes a dynamic action that executes some pl sql code that modifies the record status of the records in the grid.
When the PL SQL is finished, it returns a validate msg into a page item and I have change event checking if it is set to "Success" else display the error message.
In the false action where an error occurs I execute the following code to apply a filter to the interactive grid:
apex.region("item_updates").widget().interactiveGrid("addFilter", {
type: 'column',
columnType: 'column',
columnName: 'RECORD_STATUS',
operator: 'EQ',
value: 'Error',
isCaseSensitive: false
});
The problem is when the filter is applied the grid displays no data found and I have to refresh several times before the grid finally displays the Errored records.
Any help on this would be greatly appreciated!