Sort a grouped grid

[Kevin]

Currently I group on a hidden field like

GridHelpers.FilterableColumn(columns, m => m.Id).Hidden() .ClientGroupHeaderTemplate(".  . . . .");

And as part of the DataSource I added

.DataSource(dataSource => 
{
dataSource
. . . . . .
.Group(g => g.Add(p => p.Id))
;
})

But this seems to alter the way the grid is sorted for display. Is there a hook that I can influence the sorting for the grid?

 

 

[Viktor Tachev]

Hi Kevin,

When grouping is applied to the Grid data will be sorted internally in order for it to be grouped. If you would like to set specific order for the Grid items in each group I would suggest including the dataSource.sort option. The dojo below outlines the approach:

• https://dojo.telerik.com/apAVIXob

Specifying a sort with the MVC wrapper would look like this:

.Sort(s=>s.Add(x=>x.ContactName))

Give the approach a try and let me know how it works for you.


Regards,
Viktor Tachev
Progress Telerik

[Kevin]

Thank you. This helps a lot. In the post you mention 'Add'ing a column to sort by. Any hints on how to control the "sense" of the sort, like descending or ascending?

[Kevin]

Also when I try to do the following I get an error that there is no such method "Sort". Is this the wrong helper?

.DataSource(dataSource => 
{
dataSource
            .Sort(...)

[Viktor Tachev]

Hello Kevin,

The Sort option in the DataSource configuration should be specified after setting the DataSource type. Check out the code snippet below that illustrates a possible DataSource configuration:

.DataSource(dataSource => dataSource
    .Ajax()
    .Sort(s=>s.Add(c=>c.CompanyName))
    .Read(read => read.Action("Customers_Read", "Grid"))
    .PageSize(20)
)

Give the approach a try and let me know how it works for you.


Regards,
Viktor Tachev
Progress Telerik

[Kevin]

Thank you this works great. Do you have any tips on sorting descending?

[Viktor Tachev]

Hi Kevin,

For specifying a descending sort order you just need to include the Descending() option. Like this:

.DataSource(dataSource => dataSource
    .Ajax()
    .Sort(s => s.Add(c => c.CompanyName).Descending())
    .Read(read => read.Action("Customers_Read", "Grid"))
    .PageSize(20)
)

Let me know if you need further assistance. 


Regards,
Viktor Tachev
Progress Telerik