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
General Catalog / Class: Sorting of Numbers
Moderator: crythias
-
- Znuny newbie
- Posts: 16
- Joined: 29 Feb 2016, 20:04
- Znuny Version: 4.0.18
- Real Name: Oliver
-
- Znuny newbie
- Posts: 28
- Joined: 22 May 2015, 08:32
- Znuny Version: 5.0.25
- Real Name: David Stockinger
Re: General Catalog / Class: Sorting of Numbers
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
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
-
- Znuny newbie
- Posts: 16
- Joined: 29 Feb 2016, 20:04
- Znuny Version: 4.0.18
- Real Name: Oliver
Re: General Catalog / Class: Sorting of Numbers
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
Im not sure if i go trying to change the fields in the DB direct
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: General Catalog / Class: Sorting of Numbers
or leading zeros in text field
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 16
- Joined: 29 Feb 2016, 20:04
- Znuny Version: 4.0.18
- Real Name: Oliver
Re: General Catalog / Class: Sorting of Numbers
Of course, but that dosent look that nice....crythias wrote:or leading zeros in text field
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: General Catalog / Class: Sorting of Numbers
input fields assume text, so WYSIWYG
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask