I have a grid that allows a user to display data in both grouped and none grouped format. The datasource (ds) is using json to read the data from the server. The datasource is currently configured to do server side paging and filtering. I would like to also enable this datasource to be able to do server side grouping and Aggregates on the data.
My ds currently defines the schema: { data: "DateList", total: "TotalResults” model: { //fields are declared}}
And my grid currently defines the columns that need to be displayed.
In what format does my code need to returned the grouped data to the ds? And also how do I need to format the Aggregates that are calculated for each grouping? Keeping in mind that the grid allows for displaying of non grouped and grouped data. Do I need to change anything with how the ds is defined in regards to the schema? Do I need to change anything with how the grid is defined in regards to the column list?
An example of a grid that allows for grouped and none grouped results and does server side grouping would help.
My ds currently defines the schema: { data: "DateList", total: "TotalResults” model: { //fields are declared}}
And my grid currently defines the columns that need to be displayed.
In what format does my code need to returned the grouped data to the ds? And also how do I need to format the Aggregates that are calculated for each grouping? Keeping in mind that the grid allows for displaying of non grouped and grouped data. Do I need to change anything with how the ds is defined in regards to the schema? Do I need to change anything with how the grid is defined in regards to the column list?
An example of a grid that allows for grouped and none grouped results and does server side grouping would help.