I wonder how to sort a taxonomy field (term reference) in the Views table not by the ID but by the alphabetic order whichever the term name is. e.g Author, Issue.
To explain this further, here what I do, let say:
1) Create a content type called "Book"
2) Added some fields, one of them is "Issue" and another is "author" and both are "Term reference".
3) Created a table in Views, and in the table settings, make the headings for Author and Issue sortable.
4) When I click on the "Author" or "Issue" headings, the sorting wasn't correctly sorted in alphabetical order.
Can anyone check it out and let me know how to resolve this. Thanks!
I have done something similar. Since the View is a content view, you need to add a relationship to the "Issue" field (and "Author" field I suppose) and then you should have access to a "(Issue) Term name" under the Sort settings.
Let me know if that's not clear and I can try to expand on it.
EDIT: Here's a screenshot of what I mean