Sort integers in numerical order, not alphabetical

[txag08]

Howdy. I have a list with an Integer field called Order. The purpose of this field is to be able to sort a list of records in a desired order. It does not quite work as needed, however, because the numbers end up sorted by alphabetical, not numerical value. Is there a property somewhere that will allow this list to be sorted by numerical value? (20 comes before 100, not after!)

[Slava Savitsky · Accepted solution]

If your field is indeed of type Integer, it should be sorted by numeric values and not alphabetically without any special configuration. This is how it works for such fields in the base system (e.g. Order in Business Rules table).

[txag08]

Alright! I double checked the type and sure enough, it's a String type. I've been creating a bunch of tables with Order fields and they all are Integer type except for this one which slipped in as a String. I have corrected the issue and the order is now going in numerical order. Thanks!