Remote data but sort/filter locally?

Question

Hello,I'm loading data remotely however, some of the columns are computed so I can't sort on them in the API. Is there a way to have sorting/filtering work only on the current page of data, and then only have paging trigger an API call?Thanks,

Sujith Kumar Rajkumar · Answer

Hi Scott, 
 
Greetings from Syncfusion support. 
 
Based on the query we would like to let you know that when remote data is bound the Grid works on basis of on-demand loading and will only have access to the current page records. However, the Grid actions like, Sort, Filter, etc., need to be performed based on the entire data source. This is its default behavior and it is not feasible to perform the actions with only current page records. We also would like to inform  when remote data is bound to the Grid, all the Grid actions have to be performed on the server side and the Grid updates the view based on the response data received from the server on success. This is the default behavior of remote data adaptors. 
 
So for your case we suggest you to use one of the following approaches, 
 

You can set the ‘offline’ property as ‘true’ in the data manager instance. On enabling this property the entire data will be fetched in the initial request itself and all the consecutive actions will be performed in the client-side(considering it as a local data). More details on this can be checked in the below documentation link,
 
Documentation: https://ej2.syncfusion.com/angular/documentation/grid/data-binding/?no-cache=1#offline-mode 
 

You can use the remote save adaptor which allows you to bind the entire data to the Grid with initial server request on render and all the Grid actions will be performed in client-side except the CRUD actions(for which server request will be sent). More details on the remote save adaptor can be checked in the below help documentation link,   
 
Documentation: https://ej2.syncfusion.com/angular/documentation/grid/data-binding/?no-cache=1#remote-save-adaptor 
 

You can use ajax call to send request to your back end along with the required input values, return back the data to the client, parse the returned data to JSON format and bind it to the Grid’s dataSource property. This will be considered as local data in the Grid. More details on this can be checked in the below documentation link,
 
Documentation: https://ej2.syncfusion.com/angular/documentation/grid/data-binding/?no-cache=1#binding-with-ajax 
 
Please get back to us if you require any further assistance. 
 
Regards, 
Sujith R

Scott Price · Answer

Thanks, I'll review the options

Sujith Kumar Rajkumar · Answer

Hi Scott, 
 
You’re welcome. Please get back to us if you require any further assistance. 
 
Regards, 
Sujith R

Adam Zaghouani · Answer

Hello,As I have noticed, nothing works on the grid on the client-side if WebApiAdaptor were to be used.However, using "Offline: true" as an option isn't a solution either, because I retrieve the data by giving out a query with it. And "Offline" makes the grid ignore the query param addition for some reason.And isn't it more optimal to do those sort of things ( Sort, Filter, and search ) on the client-side rather the sever's?Is there really no other solution with WebApiAdaptor?

Sujith Kumar Rajkumar · Answer

Hi Adam, 
 
Greetings from Syncfusion support. 
 
When Web API adaptor is used for binding remote data to the Grid, all the actions need to be handled in the server-side. So it is not feasible to handle some Grid actions alone in the client-side and perform the rest in the server-side. This is the default behavior of this adaptor. 
 
So for your case we suggest you to use one of the solutions we had mentioned in the previous response to achieve your requirement. 
 
Let us know if you have any concerns. 
 
Regards, 
Sujith R