[Starson17]

Originally Posted by Merischino

Without including the entire list, here is a snippet of my list. Please note that in all cases but one (Anne McCaffrey), the Author and the Author Sort fields are populated with the exact same data

I've looked at your db, and there are lots of entries where this is not what I see.

(example I have copied and pasted "Batho, Michele" into both the "Author" and the "Author Sort" fields for Michele Batho.)

I see "Batho, Michele" in author_sort and "Michele Batho" in author. They sort correctly under "B"

Only in the case of Anne McCaffrey are some records populated with "Anne McCaffrey" as the author and "McCaffrey, Anne" as the author-sort.)

I see the opposite - "Anne McCaffrey" as the author_sort and "McCaffrey, Anne" as the author.


Are you selecting a record, pressing "E" to edit the metadata (or right clicking and choosing "Edit metadata" to see the author_sort contents?

Sometimes. then, sometimes, for no apparent reason, it switches to sortying by last name. (Doyle? Cervantes?) or by middle name maybe (the "de" in Miguel de Cervantees Saavedra maybe?)

The contents of author_sort is: "de, Cervantes Saavedra, Miguel" so it sorts under "d"

If I have "Adams, Douglas" entered for both Author and Author Sort fields, then shouldn't "Adams, Doglas" be sorting on the A of Adams, and not on the D of Douglas?

But, you don't. You have "Douglas, Adams," in author_sort.

If It is sorting on the D of Douglas, shouldn't it follow that it would sort also on the o after that D and place itself AFTER the Da in Eddings, David?

It would, but you have "Eddings, David" in author_sort, so it's sorting on "E"

If Sir Arthur Conan Doyle is entered into both the Author and the Author Sort fields in the GUI metadata as "Doyle, Sir Arthur Conan" the does it not follow that it should be sorting on the D in Doyle, not the S of Sir or the A of Arthur or the C of Conan, and that it should sort all Doyle, Sir Arthur Conan entries the same way and in the same place in the list? Why are the two "Doyle" entries not together?

You don't have the same thing in author_sort for both. You have one record where "Conan" is first in author_sort and another where "Doyle" is first. Taht's wwhy tehy aren't together.

I could go on, but it's all sorting correctly - you just have a mess in your author_sort.