I am encountering an issue where when I try to sort by a custom field with a drop-down value having numeric values which correspond to a position, it seems the number values are not being used.
My Field setup:
Title: Board Position
Name: cb_board_position
Type: Drop-Down (Single Select)
Values:Labels
1:President
2:Vice President
3:Secretary / Treasurer
4:Director, Region 1
etc...
My List setup:
Usergroups: Board Member
Sorting: Basic / Board Position / Ascending
Using this setup, I would think that when sorting by the "Board Member" field, it would order by value. It does not even seem to be ordering by label.
I've tried the following:
* Setting up the values so they have 0 prefixes in case it's using an alphabetical search - did not work. (In fact, when I went back to edit these, it seems to have trimmed the leading zeros)
* Setting up sorting to "Advanced" with the following ORDER BY clause:
ue.cb_board_position ASC
This seemed to have no effect.
What else can I try? When I use the advanced sort, is there a way I can be sure I'm sorting by value, and not by label?
Any advice would be greatly appreciated.
Thank you!
