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

RadGrid GroupByExpressions Sorting

13 Answers 422 Views

Grid

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

Eric asked on 23 Mar 2011, 04:44 PM

Hi,

I have a RadGrid that gets its data from a stored procedure and the data is already ordered in the desired way. The RadGrid's group by automatically re-orders the group by field by alphabetical order. Is there a way to leave the order of the rows in its initial state? For example, if we're grouping on column X, if B appears before A from the data source, in the RadGrid B would be the first grouping section and A the second.

If not, then is there a way I can sort the group by field by a specific field? For example, this is what I would want to do:

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldName="Category" SortField="ColumnXYZ" SortOrder="Ascending" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="Category" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

Thanks in advance!

Eric

13 Answers, 1 is accepted

answered on 08 Jul 2014, 06:18 PM

Hello Peter,

I am afraid that there is no way to remove the sorting of the Grouped data. The way the grouping functionality works is it first sorts the data and then it is grouping the data by given field. When the Grouping is performed for the Grid there is no way to understand currently grouped item in which place was before the grouping. And what about if the item was in such order that it now needs to be shown in another Group. This will break the functionality.

Another thing, when you want to perform grouping on a database level you are always forced to ORDER BY before GROUP BY. And we are also performing the grouping operation over the datasource.

Regards,
Pavlina
Telerik

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

answered on 03 Aug 2015, 08:31 PM

Searching the same issue and found this year old thread. Coming from a sql server database perspective this workaround below worked for me. Basically provide a virtual unique value from your query for your grid to groupby and sort..but display a group name in the select (sql order by in the sql is ignored going to grid but left for you to observe the results). The key here is the row_number() function that assign a value per record while sorting.

-- sql server,database query, GroupSequence = unique group or sequence ID given at query time
select g.GroupSequence, g.GroupName, sp.SalesPersonID, sp.FirstName, sp.EmailAddress
from dbo.SalesPersons sp
inner join (select row_number() over(order by Sequence, [Description], SalesGroupID) as GroupSequence, SalesGroupID, Description as GroupName from dbo.SalesGroups) g on g.SalesGroupID = sp.SalesGroupID
order by GroupSequence, FirstName

<telerik:GridGroupByExpression>
    <SelectFields>
        <telerik:GridGroupByField FieldName="GroupName"></telerik:GridGroupByField>
    </SelectFields>
    <GroupByFields>
        <telerik:GridGroupByField FieldName="GroupSequence"></telerik:GridGroupByField>
    </GroupByFields>
</telerik:GridGroupByExpression>

answered on 15 Oct 2018, 01:24 PM

general.png

Hi Pavlina,

I do not know if this is any different. I am bringing data in, in the order of My preference. I tried setting the sort order to None in the groupbyfield. My requirement is to have 'GENERAL" category on the top followed by others departments in ascending order. Please find the attached that shows how it is as of now. It has everything grouped by department in ascending order. I tried setting the sort order to none and so on but nothing seemed to work.

Thank you.