Zach,
Won’t Goutham still have the same problem?
Ordering by a text field will always be alphabetical, and return
region 1, region 10, region 11…region 2, region 21…
rather than
region 1, region 2, region 3…region 10, region 11
Right? I could actually be totally wrong here… but I guess it seems to me that using the advanced properties of the field to set the Order By clause and using a new model to set the order by clause would have the same result.
Assuming that’s the case…
Goutham, if you can create a formula field on your object that returns a number (simply strip out 'region ’ from your RegionID__c), you could order by that new field.
