Grid paging issue

If you're using gridLayout that's an editable grid, if you want your data to page you can use gridField to create a paging grid. Have a look in forum.appian.com/.../SAIL_Recipes.html for examples of both types.

Could you please attach the code snippet of the grid.

Also have a look at this example and how it uses todatasubset() on an array of data for paging in a grid forum.appian.com/.../recipe_display_array_of_data_in_a_grid.html

@akanksham , it would be helpful , if you can please provide us with the code snippet as suggested above

@akanksham The keyword gridLayout used by you is suggesting that you are making use of the Editable Grid. If you would like to go with Editable Grid, you have two options as follows:

1. Get all the 99 records at once, that is batch size = -1
2. Add the custom pagination logic to the editable grid. (that is, simulate the paging functionality we observe in the Paging Grid) If you want to go ahead with this, application at http://bit.ly/2fegMuX should serve as an example.

I assume that you are aware of the fact that Editable Grid won't paginate/sort as Paging Grid do and that's the reason why we should either show all the Records at one go or add a custom pagination logic.

I would personally recommend what @rodgraham/@tim.clarke has suggested, as Editable Grid lacks sorting and also needs a customised logic for pagination which Paging Grid already has. It's your call. I believe attaching the code snippet might not be needed at this moment as it seems to me like a decision of which component to choose.

@Are you using gridLayout() or gridField().
Please configure gridField() to get paging grid , if you are using gridLayout().

Thanks everyone for the solution.