Please help!
I have a page using interactive grid with data spanning across multiple pages. The grid requires multi row select to perform updates. I have a column 'APEX$ROW_SELECTOR' of type 'Row Selector' with the following settings
Enable Multi Select - Yes
Show Select All - Yes
My problem is to select multiple rows across pages and update all at once instead of losing selection when i move from one page to another?
I found a partial solution to this issue here (https://docs.oracle.com/en/database/oracle/application-express/18.2/aexjs/grid.html#persistSelection) using 'persistSelection' option set in javascript initialization code. With this I am able to retain the row selection across pages.
The only issue now is when I use the 'Select All' checkbox option. Here are the scenarios that doesn't work
1. Page 1 -> Select all rows using 'Select All' checkbox in the header -> Go to Page 2 -> The 'Select All' checkbox in the header still shows as checked and all the rows in page 2 are unchecked.
2. Page 1 -> Select all rows using 'Select All' checkbox in the header -> Go to Page 2 -> Select all rows using 'Select All' checkbox in the header -> Go to Page 1 -> The earlier selection made is gone and all the rows are now unchecked.
Any ideas on this?
Thanks in advance