Rows grouping in a grid

Row grouping allows to segregate or group rows with common values of some chosen fields together. It works similar to group by sql queries in database.


The group by fields are specified by setting groupModel.dataIndx as array of field names. e.g.,

groupModel.dataIndx = ['ShipCountry', 'ContactName']


Summary for every group can be displayed


Row grouping columns ( ShipCountry and Customer name ) and summary columns ( Freight ) are sorted as a whole when their header cells are clicked.

Other columns are sorted within the groups when their header cells are clicked. These cells can be sorted as a whole by pressing Ctrl key along with click on header cell.

Related API

groupModel to specify grouping options during initialization

Group to modify grouping options in run time.

and group related events