Syncfusion grid with deferred loading but dynamic search

[S]

Hello,

I am using syncfusion grid with filters to display the required data. The grid can have thousands of records. The requirement is to load only first 10 records on page load. And as the user hits the next page or page number, the data should be retrieved from database then. Also, if I want to search for some data, it should not search only from 10 records which are loaded but from all the thousands records to give apt result.

Could you please advise me on this?

Thanks

[Renjith Singh Rajendran]

Hi Customer, 

Thanks for contacting Syncfusion support. 

In Essential JS2 Grid, we have paging feature, when this feature is enabled, It will load 12 records by default. So we need to set the `pageSize` is set as 10, then it only load 10 records on page load. When you perform filtering or searching, these actions will be performed based on the entire data source of the grid, and not based on the loaded 10 records. This is the default behavior of filtering, searching and paging actions in Essential JS2 Grid. Please refer the online sample link below, 

Sample : https://aspnetmvc.syncfusion.com/Grid/DefaultFiltering#/material 

 

In the above sample, initially only 12 records will be loaded in Grid. But if the filtering action is performed, it will filter and return values based on the entire data source of Grid, and not based on the loaded 12 records. 

Documentations:   

https://ej2.syncfusion.com/16.1.37/aspnet/documentation/grid/filtering.html?syntax=razor 

https://ej2.syncfusion.com/16.1.37/aspnet/documentation/grid/searching.html?syntax=razor 

https://ej2.syncfusion.com/16.1.37/aspnet/documentation/grid/paging.html?syntax=razor 

 

Please get back  to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran.