Skip to main content

Alphanumeric Sorting

  • Jan 23, 2023 12:28 PM UTC
  • 5 replies
  • 181 views

Forum|alt.badge.img+2

Is there a particular way to address the alphanumeric fields while sorting?

I feel restricted in effectively sorting my data currently. In the attached screenshot, the alphanumeric fields make it impossible to sort the values in an ascending order.

Is my only option then is to use some other header column ?

 

5 replies

MikeCH
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • Jan 23, 2023 1:46 PM UTC

There is no other option for the sorting itself. However, you can increase the number sequence of the order no., e.g. to 1000072, then the sorting will be correct.


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Employee)
  • Jan 24, 2023 10:31 AM UTC

Thanks.

 


MikeCH
Superhero (Employee)
Forum|alt.badge.img+13
  • Superhero (Employee)
  • Jan 24, 2023 10:37 AM UTC

With pleasure. @Uniqueusername.: Please change the status of your question to “Solved” 👍🏻


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • Jan 26, 2023 8:24 AM UTC

Not a very nice solution, but what if you prepare a custom attribute (field) that is the numeric equivalent using Cast or something or add 10000 to the entered value. This would then be the new sorting field.


Franck.G
Sidekick (Employee)
Forum|alt.badge.img+8
  • Sidekick (Employee)
  • Mar 2, 2026 9:49 AM UTC

Many customers complain about this limitation, as it is present in several screens. Significant work would be required to enable sorting, as in many ERP systems.