Sorting and Grouping on same column of grid

[Chau]

I can't get sorting to work on a column that is selected as grouped.

https://plnkr.co/edit/j1FbSEGW3HLJDhbdHr2S?p=preview

On this grid, the group is defined on the column 'UnitPrice'.

Sorting on ProductName works, i.e. within each UnitPrice group (e.g. UnitPrice: 22, product id = 4 and 7 get sorted OK depending on asc/desc ProductName)

But Sorting on UnitPrice does not work, i.e. I expect to see the group header to show highest UnitPrice (e.g. Unit Price: 25) for descending order as first group header of the grid.

Is that feasible? Thanks!

[Dimiter Topalov]

Hello Chau,

The Grid built-in sorting functionality when clicking the column header is to sort the items within each group by the respective field. The groups themselves can be sorted via the built-in UI Group tag when the Grid is groupable ([groupable]="true"):





https://stackblitz.com/edit/angular-fvsxha-2p21ke?file=app/app.component.ts

You can also configure the groups sorting order via the dir property of the Group descriptor.

I hope this helps.

Regards,
Dimiter Topalov
Progress Telerik

[Chau]

Thanks Dimiter!  Using the built-in UI Group tag (with setting [groupable]="true") does allow sorting within group.

 

[Chris]

I just wrote a blog using a custom ordering for Grouping.  You might find this useful.

https://doylestowncoder.com/2021/12/14/kendo-ui-for-angular-customizing-the-order-of-grouping-in-the-grid/