Sorting by Asset Tag

  • 10 February 2019
  • 5 replies
  • 24 views

When sorting by Asset Tag column in Inventory, they don't sort correctly - for example, mine goes in the following order when I sort by Asset Tag column:

  • ASSET-1
  • ASSET-10
  • ASSET-100
  • ASSET-101
  • ASSET-102
  • ASSET-103
  • ASSET-104
  • ASSET-105
  • ASSET-106
  • ASSET-107
  • ASSET-108
  • ASSET-109
  • ASSET-11
  • ASSET-110

And ASSET-2 through ASSET-9, for example do exist



5 replies

Userlevel 1

Hi Travis,


Thanks for bringing this to our attention. Let me confirm the logic behind the sort in CMDB and will file a bug, if found to be a flaw. Will keep you posted on our findings. 

If it helps - Google APis and SSP APis work very much alike. In Google, it's simply a setting of labeling it a NUMERICAL VALUE and not Automatic or PLAIN TEXT. 


Userlevel 1

Hi Shane,


Thanks for the feedback, we will have passed on to our engineering team to figure out the best solution that we can implement around this.

This is still a problem 10 months later. We need this fixed for this 'asset management' to be viable


Userlevel 4
Badge +6

Hi Travis,


We did check with our product team and this is the current default behavior. The 'Asset Tag' field is a single-line text field that accepts alphanumeric values and is configured to follow string sort algorithm (lexicographic sorting). Hence the asset tags will be sorted alphabetically and not numerically.


I’m afraid we wouldn’t be able to modify the behavior as this will affect the functionality of other features and processes dependent on it like search tokenization, etc. Let us know if you require any further clarification.


Regards,

Sanofar

Reply