View Single Post
Old 01-16-2011, 10:18 AM   #17
peaceridge
Wizard
peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.peaceridge ought to be getting tired of karma fortunes by now.
 
peaceridge's Avatar
 
Posts: 1,019
Karma: 4407864
Join Date: Feb 2009
Location: North Carolina
Device: Kobo Aura1, Nexus7.2, Galaxy Tab A 8.4, Ipad Air & Mini 6
What I would like is an option NOT to sort within the tag name at all - leave it just like I enter it. For example, I would like to have a value that says: "Health, Diet" and one that says "Heath, Vitamins", so that when I sort on the tag column all the Health are together instead of "Diet, Health" coming before "Health, Vitamins" or "Health, Diet" coming before "Vitamins, Health" - depending on whether it is ascending or descending. I've tried creating my own column, but got things like [1] at the end of the values.

UPDATE: As I was writing this, I had an idea that works perfectly - use a ":", so that I enter "Health: Vitamins" and "Health: Diet", sorts great and looks just like I entered them. I'm going to go ahead and post this (even though I have my answer) just in case someone else is looking through this thread for this kind of problem. Hopefully, using a colon won't cause some other problem in the database.




Quote:
Originally Posted by chaley View Post
I submitted a change that sorts the tags in case-insensitive alpha order when they are read from the database. Assuming the change is accepted, tags columns will sort as they visually appear. Note that this is a string sort, meaning that numbers will sort by their characters. Example: the tags 1, 2, 10 will sort 1, 10, 2.
peaceridge is offline   Reply With Quote