Grouping, Sorting by Associated Properties

[Frank]

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

[Atanas Korchev]

Hi Frank,

A similar scenario is shown in our ajax binding demo. We have a column bound to Customer.ContactName and I can group by it without a problem.

What exactly is the error message you are receiving?

Regards,
Atanas Korchev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Frank]

I tried using the code in the Ajax demo but I got a JavaScript error in jQuery 1.4.2 at a line which reads
j=a.length,
because a is undefined.
When I continued in the debugger I got an empty grid.
I am using the MVC1 version of the DLL.
I've also tried the 329 version with the same result.

[Frank]

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();
    }
%>

[Atanas Korchev]

Hello Frank,

Unfortunately I cannot help without seeing a project which shows the problem. You can host a runnable project somewhere where we can download it.

Regards,
Atanas Korchev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Morten Mertner]

I can really recommend to include this link when requesting samples from end users :-)