 |
Browsing around demo.racktables.org, the tags look sorted to me. Please provide steps to reproduce and/or screenshots. |
|
|
Closing ticket, please re-open if you can provide steps to reproduce the sorting issue. |
 |
Sorry I missed your reply on the 9th. Here is my convo with Dennis back In June: Denis Ovsienko denis@ovsienko.info via freelists.org Jun 2 to racktables-use. ---- On Thu, 01 Jun 2017 15:48:14 +0100 Chris James<chris@datacate.com> wrote ---- > Hi all, > > I am noticing as we are using more and more tags for the first time they do not appear in alphabetical order when selecting from the drop down. Is it possible to fix this or is this a setting I am missing? Hello Chris. I have poked around relevant bits of code a little and found two cases where the tags sort order is not alphabetical (it is not the same even between those two cases). This looks like a bug but I could not see a proper solution for it today. |
|
|
Screenshot Capture.PNG (28,770 bytes) |
|
|
Also - This still exists in 20.14 as well. I am unable to update the version in the ticket. |
 |
What I remember is that the very first implementation of tags in RackTables used PHP sorting. Quite soon it turned out the sorting only worked well for the 7-bit ASCII tags because PHP at that time wasn't equipped to compare UTF-8 strings properly (the fact this bug exists and my comment above may be due the same reason still standing, I cannot tell reliably right now). As a solution to that problem I changed the code to make the MySQL server sort the tags (traditionally it gets character sets much better) and then in PHP to save the order of the table row into "ci" (collation index) PHP array key such that a simple numeric sorting by that key would reproduce the MySQL order. For a while that worked quite well. A few years later the "ci" key was removed, probably because it was blocking some other internal change, and some other PHP-level code put into place to sort the tags, I presume that time it worked otherwise there would be bug reports. But apparently right now it does not work as intended. |
- Anonymous
