Quote:
Originally Posted by peaceridge
I don't suppose I could create a column made from other columns, ie the tag column and replace any "." with a "-", then I could sort on it?
|
You could sort on it but you likely won't get what you want.
The problem is that a book usually has more than one tag and there is no universally-accepted order for the tags. Consider a book that has three tags: Vampire, Fiction, and Mystery. If you sort by tags, what is the book's sort order: "Fiction, Mystery, Vampire", "Fiction, Vampire, Mystery", "Mystery, Fiction, Vampire", "Vampire, Fiction, Mystery", or any of the other combinations of the tags? There is no right answer other than "what you want at the moment", and the computer has no way to read your mind.
If a book has no tags or 1 tag than your suggested scheme will work, even without the changing of dot to dash. But how do you guarantee at most one value? This is what I was getting at with my "difficult" suggestion: you create columns for each the single tags on which wish to sort. It is hard to believe that the complexity of setting this up and managing it is worth the benefit you get.