Grid Server Grouping By Id

[Marcin]

Hello
I have following data:

user_id, user_first_name, user_surname, some_other_data

On Grid I'm displaying it in following way

UserDisplayName (user_first_name + ' '+ user_surname), Some Data

Now I would like to group data by user. So in fact on database level it should be grouped by user id but then it should display in grid group header proper user display name.

I know how to achieve such grouping by simply replacing proper memeber in group descriptor on DataSourceRequest object, but Then group header is wrong.
Probably it would be possible to somehow on fly replace that values?

But I believe it would be still a problem with sorting.

Is such server grouping is possible? In linq I can define multiple columns to group, but have no idea how to apply that to data source.

Kind Regards
Marcin

[Alexander Popov]

Hi Marcin,

Basically, the group header has access to the name of the field that the data is grouped by and its value. In the current scenario you could use the groupHeaderTemplate to call a custom function that returns a string, matching the ID. For example: 

{field: "user_id", groupHeaderTemplate: "#=getStudentNameByID(value)#"}
...

function getStudentNameByID(user_id){
    //custom implementation ...
    name = "test"
    return name;
}

Implementing this on the server-side is possible, however that would require a custom solution that is beyond the scope of our support services.

Regards,
Alexander Popov
Telerik