Datto Autotask PSA: When sorting my Service Desk queues by number column in Admin, the queues are not sorting in numerical order

Follow

Issue

When sorting my service desk queues by the number column in Admin, the queues are not sorting in numerical order.

Environment

  • Datto Autotask PSA

Cause

The number column is a text field and sorts differently than a numeric field.

Resolution

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.

Example

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.


Was this article helpful?

0 out of 1 found this helpful

You must sign in before voting on this article.

Want to talk about it? Have a feature request?

Head on over to our Community Forum or get live help.

For more Business Management resources, see the Datto RMM Online Help and the Autotask PSA Online Help .

Datto Homepage