Database Server Mode Limitations
In server mode, the Bootstrap Grid View does not have simultaneous access to bound data in its entirety. This imposes certain limitations on the grid’s features, which are still available in regular binding mode. Please see the list below for information on features that are not supported in database server mode:
- filtering and sorting data by display text (not by edit values);
- searching through display text of grid data cells using the search panel;
- case-sensitive filtering; the grid converts a search string to lower-case before filtering;
- custom sorting (ASPxGridView.CustomColumnSort) and custom grouping (ASPxGridView.CustomColumnGroup);
- group modes specified by the GridViewDataColumnSettings.GroupInterval property (rows are always grouped by the values of grouping columns);
- calculating custom summaries using the ASPxGridBase.CustomSummaryCalculate event;
- calculating summaries for unbound columns whose values are provided using the ASPxGridView.CustomUnboundColumnData event. Summaries can still be calculated for unbound columns that are populated using expressions (see GridViewDataColumn.UnboundExpression);
- sorting, grouping, filtering and summary calculation for unbound columns whose values are provided using the ASPxGridView.CustomUnboundColumnData event; these features are still supported for unbound columns that are populated using expressions (see GridViewDataColumn.UnboundExpression);
- selection of all grid rows using the built-in SelectAll check box (when the GridViewCommandColumn.SelectAllCheckboxMode property is set to AllPages).