jQuery DataGrid - remoteOperations
Server-side data processing improves the widget'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 widget 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 widget 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 widget) |
paging, filtering, sorting | grouping3, summary calculation1 |
remoteOperations: { filtering: true } |
filtering | - |
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 widget.
- If group summary calculation is used.
- If grouping.autoExpandAll is set to false.
The following restrictions apply to widget functionality when operations are remote:
Columns with the calculateCellValue or calculateDisplayValue option set cannot be sorted, filtered, or used for grouping.
The calculateGroupValue and calculateSortValue options accept only string values.
Custom summary calculation is not supported.
The calculateFilterExpression option 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.
Remote group paging does not apply if you set the grouping.autoExpandAll option to true or call the expandAll(groupIndex) method.
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 calculation must be performed on the server.