how to retrieve the next batch of rows using DataTable
how to retrieve the next batch of rows using DataTable
Hi,
I just started using jquery DataTable and as you can guess, I am completely new to it.
I am using jquery DataTable in my SharePoint Project and I search the data using CSOM Search API. At the moment the search returns 2123 items in total. However, I have set a limit of 500 rows at a time. So the datatable displays only 500 items.
Now, how can I get the next 500 rows? DataTable has a next button but that onces it reaches 500th row does not retrieve the next batch of rows. How can I retrieve the next 500 rows? Or do I have to retrieve them all at once? It seems that the datatable search, searches only the rows which have been retrieved.