JavaScript/jQuery DataGrid - remoteOperations

Notifies the DataGrid of the server's data processing operations.

Type:

|

Default Value: 'auto'

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	filtering¹, sorting¹, summary calculation¹
`remoteOperations: { paging: true }` (with grouping used in the UI component)	paging, filtering, sorting	grouping³, summary calculation¹
`remoteOperations: { filtering: true }`	filtering	grouping⁴
`remoteOperations: { sorting: true }`	sorting	filtering¹
`remoteOperations: { grouping: true }`	grouping, filtering	sorting¹, summary calculation¹
`remoteOperations: { summary: true }`	summary calculation	filtering¹, sorting², grouping²

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).

NOTE

Paging, filtering, and sorting are performed on the server side for the ODataStore, but you can change them to the client side by setting the corresponding remoteOperations fields to false. Other operations are always client-side.

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

filtering

Specifies whether or not filtering must be performed on the server side.

Type:

Boolean

Default Value: false

grouping

Specifies whether or not grouping must be performed on the server side.

Type:

Boolean

Default Value: false

View Demo

groupPaging

Specifies whether paging by groups should be performed on the server side.

Type:

Boolean

Default Value: false

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.