Hi There
I have a string column with the day names of the week, ie Monday, Tuesday, Wednesday. When I sort by that column, it needs to be in the order of the day of the week, but at the moment as its a string it sorts alphabetically.
I dont have access to change the SQL query all I can do is try to convert it in the grid.
Is there some sort of sort converter or extension that I can apply to re sort the column?
Thanks for your help
Nick
I have a string column with the day names of the week, ie Monday, Tuesday, Wednesday. When I sort by that column, it needs to be in the order of the day of the week, but at the moment as its a string it sorts alphabetically.
I dont have access to change the SQL query all I can do is try to convert it in the grid.
Is there some sort of sort converter or extension that I can apply to re sort the column?
Thanks for your help
Nick
3 Answers, 1 is accepted
0
Hi Nick Wood,
Sure , you can hook to the Sorting Event of RadGridView and perform your own sorting logic over the items in the rows as demonstrated in this online example
Regards,
Pavel Pavlov
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.
Sure , you can hook to the Sorting Event of RadGridView and perform your own sorting logic over the items in the rows as demonstrated in this online example
Regards,
Pavel Pavlov
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.
0
Nick Wood
Top achievements
Rank 1
Rank 1
answered on 25 Mar 2010, 10:46 AM
Hi, thanks for the help, but this does not fill in the gaps.
The example shows how to sort based on another column that exists in the grid, but what I need is a converter that converts the inputed day of the week name to an integer ie Monday = 1 and then sort based on the integer.
Nick
The example shows how to sort based on another column that exists in the grid, but what I need is a converter that converts the inputed day of the week name to an integer ie Monday = 1 and then sort based on the integer.
Nick
0
Hi Nick Wood,
I have prepared a small sample for you - it utilizes the custom sorting approach mentioned before.
Plese find it attached.
All the best,
Pavel Pavlov
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.
I have prepared a small sample for you - it utilizes the custom sorting approach mentioned before.
Plese find it attached.
All the best,
Pavel Pavlov
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.