Quote:
Originally Posted by BetterRed
@chaley: that raises two questions:
[*]If the authors table has the 'definitive' author_sort value (assuming that's the one that gets altered in Manage Authors) why the need for an author_sort column in the books table - the definitive value(s) is/are available via the books-author-link table?
|
It is there for both historical reasons and because from time to time someone wants to change the computed author sort for a book. One example I have seen is that the person wanted the sort to list the authors in a different order than that listed on the book.
Quote:
|
[*]But, how is it possible that the books table author_sort column can even acquire the 'wrong' value (other than by poking it into the db itself). If I fire up the MDE for one of Maddy St John's books I see my "St John, Madeleine" in the Author sort box on a green ground.[/LIST]BR
|
You can change it in edit metadata or some plugin. I think that importing a book will set it if the book has calibre metadata.