When sorting my Service Desk Queues by number column in Admin, the queues are not sorting in numerical order.
- Datto Autotask PSA
The number column is a text field and sorts differently than a numeric field.
If you had numbered queues from 1 through 15 and sorted your Queues by number, they would appear in the following order: 1, 10, 11, 12, 13, 14, 15, 2, 3, 4, 5, 6, 7, 8, 9.
The number column fields are string fields, not number fields. Because of this, it supports letters and numbers in that field. String fields sort differently than number fields, so the system looks at the first digit of a number for sort order.