We are experiencing an issue with the Oracle APEX Interactive Grid where selected rows get deselected when navigating across pages or applying filters.
Behavior observed:
- Users select multiple rows on page 1 of the Interactive Grid.
- After moving to page 2 and then back to page 1, previously selected rows are no longer selected.
- Similarly, if a filter is applied, rows are selected, and then the filter is changed again, the previous selection gets lost.
Expected behavior:
Row selections should be retained across pagination and filter changes, at least on the client side, unless explicitly cleared or the region is refreshed.
How can we retain selected rows in an Interactive Grid after pagination, applying new filters, or changing filters even after refresh?