General Catalog / Class: Sorting of Numbers

[Rasputin80]

Hello,

Anybody got an Idea how i get those number correct sorted, see screenshot. The order is exactly the same in the Dropdown in the Config Items.




Many thanks
Oliver

[DaSto]

Hy!

I guess it's not an answer for you because i don't use ITSM but i can see that this list is kind of "perfectly" sorted.
I guess in the Database these values are type of "strings/varchar/text". Text fields are sorted like that (1,10,2,3,4,...). If the value would be of a numeric/int/long/etc. datatype it would be sorted like you expect (1,2,3,4,10,...).

I don't know if this list is generated by OTRS or by yourself but i think the problem is (like i said) the datatype of the values.


Cheers

[Rasputin80]

If i understand you, its not that easy to get that soring right?
Im not sure if i go trying to change the fields in the DB direct

[crythias]

or leading zeros in text field

[Rasputin80]

or leading zeros in text field

Of course, but that dosent look that nice....

[crythias]

input fields assume text, so WYSIWYG