This is a migrated thread and some comments may be shown as answers.

Grouping, Sorting by Associated Properties

5 Answers 104 Views

Grid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Frank asked on 12 Apr 2010, 07:55 AM

My Subscription datamodel class contains a SubscriberId with an association to a Person class containing a FullName property.
A grid defined like this works just fine - the FullName value is displayed in the grid correctly:

    
                Html.Telerik()  
        
                    .Grid(Subscriptions)  
        
                    .Name("MainGrid")  
        
                    .Columns(columns => 
        
                        {  
        
                            columns.Bound(S => S.Person.FullName);  
        
                            columns.Bound(S => S.SubjectClassType);  
        
                            columns.Bound(S => S.SubjectName);  
        
                        }  
        
                    )  
        
                    .Filterable()  
        
                    .Pageable(paging => 
        
                        paging.PageSize(10)  
        
                        .Style(GridPagerStyles.NextPreviousAndNumeric)  
        
                        .Position(GridPagerPosition.Bottom)  
        
                    )  
        
                    .Render();

But when I try to group the grid items by s.Person.FullName, I get an exception that there is no SQL function to get the value.

    
                    .Groupable(grouping => grouping.Groups(groups => 
        
                    {  
        
                        groups.Add(s => s.Person.FullName);  
        
                        groups.Add(s => s.SubjectClassType);  
        
                        groups.Add(s => s.SubjectName);  
        
                    }))

I can group by the SubscriberId, but I don't want to display a Guid in the grid. Is there a way to do what I'm trying to do?

Frank

5 Answers, 1 is accepted

answered on 13 Apr 2010, 07:24 AM

The exact error was
"The member 'FelixGO.Models.Person.FullName' has no supported translation to SQL." I can send the stack trace if necessary.

I am using server binding.

If I replace the Person.FullName grouping item with SubscriberId, the grid is grouped correctly, but is completely expanded. When I click on the collapse gizmo, nothing happens.Is there a way to specify a completely collapsed grid?

Again, I am using the MVC1 version of the Telerik.MVC.dll.

    
            <%    
        
                using (Html.BeginForm())  
        
                {  
        
                    IEnumerable<EventSubscription> EventSubscriptions = ViewData["EventSubscriptions"] as IEnumerable<EventSubscription>;  
        
                    Html.Telerik()  
        
                        .Grid(EventSubscriptions)  
        
                        .Name("MainGrid")  
        
                        .Columns(columns => 
        
                        {  
        
                            columns.Bound(S => S.Person.FullName).Width(200);  
        
                            columns.Bound(S => S.SubjectClassType).Width(200).Title("Refers To");  
        
                            columns.Bound(S => S.SubjectName).Width(200).Title("Name");  
        
                            columns.Bound(S => S.OnboardingActivityStatus.Name).Width(100).Title("Status");  
        
                        }  
        
                        )  
        
                        .Groupable(grouping => grouping.Groups(groups => 
        
                        {  
        
                            groups.Add(s => s.Person.FullName);  
        
                            groups.Add(s => s.SubjectClassType);  
        
                            groups.Add(s => s.SubjectName);  
        
                        }))  
        
                        .Sortable(sorting => sorting.SortMode(GridSortMode.MultipleColumn))  
        
                        .Filterable()  
        
                        .Pageable(paging => 
        
                            paging.PageSize(10)  
        
                            .Style(GridPagerStyles.NextPreviousAndNumeric)  
        
                            .Position(GridPagerPosition.Bottom)  
        
                        )  
        
                        .Render();  
        
                }  
        
            %>