LCA sort by “ascending” order

21 views
0
0 Comments

Im trying to sort Ethernet Port name by asccending order however, Ive tried several operators Sort by, Then sort by however cannot get expected result. I end up with Sort ascending order but all 1's for example 1,10,11,12,13,.... then all 2's 2,20,21,22,23

has anyone seen this and what I need to do to resolve?

Thanks

Matthijs Favorel [SLC] [DevOps Advocate] Answered question 3 hours ago

1 Answer

1
1.60K 1 Comment

Hi Juan,

This 'natural' sorting seems easy for us, but it's not that easy for a DB to do this (note that most of the sorting is happening on the DB for performance reasons).

There is however a way to achieve what you are after, although it requires some extra work in an ad-hoc data source, see this guide.

Juan Chavez Posted new comment 2 hours ago
Juan Chavez commented

Thank you @Matthis.Favorel for the details information, I will get with one of our developers to create GQI for this. Will update thread when's we are able to sort numerically in ascending order