Select All checkbox doesnt work as expected in grid with is unoptimized

Hi,

My pega version is infinity 23.1 .

Select All checkbox doesnt work as expected in unoptimized grid. When pagination is applied and when clicked on next page it unselects rows . We have tried manually checking them with DT but filters or sorting wouldnt be applied and the source is given as savable datapage. Can anyone please help on this. And acc to our requirement we cant use optimized grids as we would need expandable sections.

@bhavanar2393 - As the filtered data is not stored anywhere in clipboard we cannot make use of data transform to loop through to select all the records across pagination. The filtering and sorting operations are done from User side and the changes are not stored anywhere. Because of this on refresh of the screen , the changes wont retain. For storing every filtered data will cause performance issue and clipboard will become heavy. Due to which Pega is not storing data anywhere.

Thank you.