Angular DataGrid - remoteOperations

Specifies DataGrid operations to be executed on the server side.

Selector: dxo-remote-operations

Type:

Boolean

|

Object

|

Mode

Default Value: 'auto'

Server-side data processing improves component performance with large datasets. The following table lists remoteOperation configuration values and which operations each value affects:

Setting	Enabled server-side operations
"auto"	If the component dataSource is an OdataStore, filtering, sorting, and paging. If you implement another data source type, no operations are enabled.
`true`	All operations except group paging.
`{ groupPaging: true }`	All operations including group paging.
`{ paging: true }`	Paging, filtering, sorting, and summary calculation, as well as grouping if autoExpandAll is disabled.
`{ filtering: true }`	Filtering, as well as grouping if DataGrid contains a lookup column and syncLookupFilterValues is enabled (default).
`{ sorting: true }`	Sorting and filtering.
`{ grouping: true }`	Grouping, filtering, sorting, and summary calculation.
`{ summary: true }`	Summary calculation and filtering, as well as sorting and grouping if summary.groupItems[] is configured.

The following restrictions apply when operations are remote:

DataGrid does not sort, filter, or group columns that implement calculateCellValue or calculateDisplayValue.
The calculateGroupValue and calculateSortValue properties accept only string values.
DataGrid ignores the calculateCustomSummary property.
The component ignores calculateFilterExpression properties that return a function or a filter expression containing a functon.

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.