[Solved] Issue with Sorting and grouping with Domain datasource

[Vara Prasad]

I am facing issue with sorting and paging when using radgridview with domain datasource.
The problem is that the sorting and grouping is being applied only for the rows present on the current page index.
In the examples, the demo shows the same too.
I want the sorting & grouping to be applied to all the records in the gridview datasource instead of only for the rows present in the current page index.
Any help would be greatly appreciated.

[Vlad]

Hi,

Indeed grouping is not applied on the server however both sorting and filtering are transferred from the grid to DomainDataSource and applied server side. You can check this using Firebug.

Sincerely yours,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Pratush Bajpai]

Hi Vlad,
If this issue with grouping not being applied on server is known, are there any plans to get this fixed / or any workarounds in future relases? We are making a heavy use of grouping and it is kind of a must have feature.
Appreciate your help..

Thanks,
Pratush

[Vlad]

Hi Pratush,

Indeed we will do our best to provide support for this in our upcoming Q3 release (early November).

Greetings,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Vara Prasad]

Hi Vlad,

Could you please send the script for showing the sorting up and down arrows for RadGridView.

I am using the following code for custom sorting.

      private void Grid_Sorting(object sender, GridViewSortingEventArgs e)
        {            
            if (e.OldSortingState  == SortingState.Ascending)
                e.NewSortingState = SortingState.Descending;   
            else
                e.NewSortingState = SortingState.Ascending;
        }  

I don't see any property called arrow or any event  "OnGridViewCellFormating" for enabling or disabling the visibility of column arrows.

Thanks,
Vara

[Vlad]

Hello,

Sorting icons can be controlled with SortingState property of the column. You can check this demo for more info:
http://demos.telerik.com/silverlight/beta/#GridView/Performance/ServerSide

Sincerely yours,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[brandon]

Any update on the grouping issue?  I am experiencing the same issue on the latest internal Q3 build.

[Stefan Dobrev]

Hi Brandon,

You can currently use the Grouping event of the grid and create RIA's GroupDescriptor similarly as we do with the FilterDescriptors. Unfortunately if you have a page size defined it is a RIA Services behavior to pull only specific number of items disregarding the grouping. For example if you bind the Microsoft's DataGrid to a RIA Service via DomainDataSource you will experience the same behavior.

Best wishes,
Stefan Dobrev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Mark D Rushton]

I understand the inherent issue with how a DomainDataSource works, but will there be a workaround for grouping in a GridView to allow for the expected behavior of grouping all records, and not just those in the loaded subset?

[Vlad]

Hi Mark,

Grouping is already added and it will be part of our upcoming service pack later today or tomorrow.

All the best,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Mark D Rushton]

Great, Vlad.  Thank you for the prompt update.

-MDR