LCA sort by “ascending” order

320 views
5
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 18th December 2024

1 Answer

7
1.97K 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 Edited comment 18th December 2024
Juan Chavez commented

Thank you @Matthis.Favorel for the detailed 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