ALERT: Datto Drive Cloud service will no longer be available as of July 1, 2019. For more information, see our end-of-life article. If you'd like to migrate your data to Datto Workplace, see our migration guide.
To learn how to download your Datto Drive Cloud data, please visit this article.

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 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.

For Example, 

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.

Resolution

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.


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.