Possible to Sort a picklist?
We are using the priority of 1 till 10. Using a picklist this results in:
1
10
2
3
4
etc.
Hence we would like:
1
2
3
etc.
The field type is set to Integer, and using a global list shows same result.
Is it possible to assing a sort order of type?
[301 byte] By [
Googhum] at [2007-12-17]
This doesn't work in Beta 3, but we're investigating a fix for RTM (it's not trivial when we have to take other cultures into account).
For Beta 3, we sort as strings. The best I can suggest for now is to prefix the integer values thus:
01
02
03
..
10
11
12
etc
Unfortunately, the answer is No. All picklists are sorted alphnumerically. So, 10 comes after 1 and before 2. The reason is not a great one. Internally, everything is basically treated as a string. We have this on our list, but it was decided to postpone fixing it until after Version 1.
My recommendation: Use Rank if possible. It is a string field. All you should have to do, is make sure to prefix 0-9 with a 0 (ex. 00, 01, 02, ...). Keep priority values less than 2 digits.
/Jason
Actually you can't prefix the Integer field's values with a 0. When you choose that value, it will essentially remove the 0 when verifying the value and then compare it to the one in the list as a string. This leaves you with an invalid value.
See my recommendation below. I typed a little slower than John ;)
