Devextreme Grid remote grouping Sql Query formation
I am evaluating this devextreme grid for its remote grouping feature. However I am unable to get enough idea on how to form my SQL Server query to support remote grouping. There aren't enough demos available that can help me getting the idea o how to prepare my SQL query to support the remote grouping feature on devextreme datagrid. Has anyone ever worked on that scenario?
I suggest you to read the documentation section for Remote Grouping, It works when you assign a remote data source to the grid control eg OData .
The DataGrid widget allows your end users to shape data as needs dictate. In this example, we demonstrate the use of the built-in data grouping feature against a remote data source. Data is provided by an OData service and grid content is grouped by both Country and City columns. Note that this demo uses the DataGrid in a virtual mode and loads data on-demand as the grid content is scrolled vertically.
See the reference documentation guide for Data Source Examples .
References:
How to implement a data service for dxDataGrid based on Web API
dxDataGrid - How to display data from WCF OData data service