Free Webinar: [New] Patch management for remote teams | 10AM PST - 28th May, 2020 Save your seat

Start a new topic
Solved

Sorting by Asset Tag

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

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. 

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

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

Login or Signup to post a comment