When sorting my service desk queues by the number column in Admin, the queues are not sorting in numerical order.
- Autotask PSA
The number column is a text field and sorts differently than a numeric field.
The number column fields are string fields, which support both letters and numbers. String fields sort differently than number fields in that the system looks at the first digit of a number for the sort order.
If you number queues from 1 through 15 and sort your queues by number, they will appear in the following order: 1, 10, 11, 12, 13, 14, 15, 2, 3, 4, 5, 6, 7, 8, 9.