Server-side data processing improves the UI component's performance on large datasets. When the server does not implement particular operations (and/or the corresponding remoteOperations fields are false) they are executed on the client. Note that the UI component may send queries to the server while executing a client-side operation.
The following table lists the possible remoteOperations configurations and the operations the server should implement. The server should also implement additional operations depending on the used UI component functionality.
|Setting||Required server-side operations||Additional server-side operations|
||all operations except group paging||-|
||all operations including group paging||-|
||paging||filtering1, sorting1, summary calculation1|
(with grouping used in the UI component)
|paging, filtering, sorting||grouping3, summary calculation1|
||grouping, filtering||sorting1, summary calculation1|
||summary calculation||filtering1, sorting2, grouping2|
- If this functionality is used in the UI component.
- If group summary calculation is used.
- If grouping.autoExpandAll is set to false.
- If DataGrid contains a lookup column and syncLookupFilterValues is set to true (default value).
The following restrictions apply to UI component functionality when operations are remote:
Columns with the calculateCellValue or calculateDisplayValue property set cannot be sorted, filtered, or used for grouping.
The calculateGroupValue and calculateSortValue properties accept only string values.
Custom summary calculation is not supported.
The calculateFilterExpression property does not apply if it returns a function or a filter expression that contains functions.
Web API Service Demo Custom Service Demo
- Data Binding: Web API, PHP, MongoDB | Custom Sources
Specifies whether or not filtering must be performed on the server side.
Specifies whether or not grouping must be performed on the server side.
Remote group paging allows you to load groups from a remote source in portions. This feature speeds up grouping because the DataGrid transmits less data. However, requests are more frequent because the DataGrid sends several requests each time a user expands a group or sorts/filters data.
Remote group paging has the following specificities:
All other operations (filtering, paging, grouping, sorting, and summaries calculation) should also be remote.
The following conditions should be met:
Disable the grouping.autoExpandAll property.
Disable the column.autoExpandGroup property for the column the DataGrid is grouped by.
If you call the expandAll(groupIndex) method, remote group paging does not apply.
Specifies whether or not paging must be performed on the server side.
Specifies whether or not sorting must be performed on the server side.
Specifies whether or not summaries summaries are calculated on the server-side.