JavaScript/jQuery DataGrid - remoteOperations
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 |
|---|---|---|
remoteOperations: true |
all operations except group paging | - |
remoteOperations: { groupPaging: true } |
all operations including group paging | - |
remoteOperations: { paging: true } |
paging | filtering1, sorting1, summary calculation1 |
remoteOperations: { paging: true }(with grouping used in the UI component) |
paging, filtering, sorting | grouping3, summary calculation1 |
remoteOperations: { filtering: true } |
filtering | grouping4 |
remoteOperations: { sorting: true } |
sorting | filtering1 |
remoteOperations: { grouping: true } |
grouping, filtering | sorting1, summary calculation1 |
remoteOperations: { summary: true } |
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
See Also
- Data Binding: Web API, PHP, MongoDB | Custom Sources
filtering
Specifies whether or not filtering must be performed on the server side.
grouping
Specifies whether or not grouping must be performed on the server side.
groupPaging
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.
paging
Specifies whether or not paging must be performed on the server side.
sorting
Specifies whether or not sorting must be performed on the server side.
summary
Specifies whether or not summaries summaries are calculated on the server-side.