Unable to save all selected row objects from multiple pages while using SAIL

Please share code snippet, most likely you have define gridSelection under with() function.

You can not select rows from multiple pages in the grid. It's per page since when you define gridSelection and you define pagingInfo in the gridSelection. To solve your problem, you can have Add button under grid and when user clicks on add the selected rows get stored into local variable lets call it as local!selectedData. When user goes to next page in grid and select some rows then again clicks on Add for which you will have to use append(local!selectedData, index(local!gridDatasubset, local!gridSelection.selected, null)) in saveInto of Add button and you can show that data in another grid. And that's how you will have all the selected rows data in local!selectedData. Let me know if that makes sense.

@omkark sorry but what you say above isn't correct, you can save multiple values whilst paging through a resultset as long as the identifiers in the gridField match the PK value from the query.
@jayashrib223 if you can paste a code snippet perhaps someone can spot why it's not working for you.

There is an example here of the correct config:
forum.appian.com/.../SAIL_Recipes.html

You might want to double check your grid selection and what variable(s) you're using to save your selections. It shouldn't be refreshing each time you change a page. Could you elaborate on what you mean by not having a complete dataset?

It's hard to say without looking at the code, but you should be able to take the selected identifiers and check against whatever dataset you're using for the grid row details to get the selected row details.

@tim.clarke: no worries. thanks for clarifying and which makes sense.

Thanks all for the suggestions. Please find the attached code. Here if I print selected IDs - "selected record IDs" , I am getting all expected IDs from different pages but how to get related complete row data together for all selected

Grid.txt