Change sorting order behavior for columns with pick list values

Please change the behavior for sorting anny view for any entity to the label
name instead of the value of the label.
as Microsoft CRM 3.0 has a bit strange way of the sorting behavior in views
for columns with pick list values

When in a view (any view for any entity)
When a column is a pick list field
When I sort the view on the column which is a pick list field

The sorting order is not by label name
The sorting order is not by order in the pick list
The sorting order appears to be on the value belonging to the label

result looks to be un-logical

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=0e03b09b-84a4-49ea-b55f-2d236748344a&dg=microsoft.public.crm

Hereward
Wed Feb 28 11:23:27 CST 2007



"Leo Rietbergen" wrote:

> Please change the behavior for sorting anny view for any entity to the label
> name instead of the value of the label.
> as Microsoft CRM 3.0 has a bit strange way of the sorting behavior in views
> for columns with pick list values
>
> When in a view (any view for any entity)
> When a column is a pick list field
> When I sort the view on the column which is a pick list field
>
> The sorting order is not by label name
> The sorting order is not by order in the pick list
> The sorting order appears to be on the value belonging to the label
>
> result looks to be un-logical
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=0e03b09b-84a4-49ea-b55f-2d236748344a&dg=microsoft.public.crm

The picklists appear to be sorted based on the AttributeValue column in the
StringList table. There is another column in that table, DisplayOrder, which
appears to be the one intended to determine the display order, but in actual
fact doesn't seem to be used.