remoteOperations

Specifies the operations that must be performed on the server side.

Default Value: 'auto'

Data for the DataGrid can be stored on the client or come from the server. As a rule, manipulating data on the server enhances DataGrid performance. However, the server might be falling short of implementing certain operations, in which case, they can be performed on the client.

Data operations can be categorized into basic operations (filtering, sorting, paging) and advanced operations (grouping, group paging, summary calculation). The following table shows where data operations are performed by default.

Basic operations Advanced operations
CustomStore client client
ODataStore server client (always)
NOTE
You cannot perform data operations on the server with an ArrayStore, a LocalStore or an array of objects.

To control individual operations, assign a Boolean value to a corresponding field of the remoteOperations object. To control all operations simultaneously, assign a Boolean value directly to the remoteOperations option.

NOTE
If you assign true to remoteOperations, the group paging feature is still performed on the client. To delegate it to the server, assign true to the remoteOperations.groupPaging, but note that with this setting, all other operations are delegated to the server also.
NOTE
If actual data is stored on the server, making data operations local does not guarantee that there won't be any queries for data to the server while these operations are being performed. It only guarantees that calculations will be performed on the client.

Note that when operations are performed remotely, the DataGrid does not support:

View 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

groupPaging

Specifies whether or not paging by groups must be performed on the server side.

Type: Boolean
Default Value: false

Note that remote group paging has a number of restrictions:

  1. Filtering, paging, grouping and (if needed) sorting, should be performed remotely.
  2. Initially, all groups should be collapsed. For this purpose, set the grouping.autoExpandAll option to false.
  3. The widget does not support remote group paging in case the expandAll(groupIndex) method is called.
NOTE
When groupPaging is enabled, all other operations (filtering, sorting, paging, grouping and summaries calculation) also become remote.

For details, see the Remote Group Paging topic.

paging

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

Type: Boolean
Default Value: false

sorting

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

Type: Boolean
Default Value: false

summary

Specifies whether or not summaries calculation must be performed on the server.

Type: Boolean
Default Value: false
NOTE
When summary calculation is remote, the widget does not support custom summary calculation.