|
I should add that the desired end-state is that in my view, Calibre should uniformly sort based on the actual metadata entered into the Author-Sort field unless and ONLY unless there is nothing in the Author-Sort field, in which case it should uniformly sort on what is in the Author field.
This expecation would work like this:
Metdata for 3 authors entered as follows
Author Field Author-Sort field
Anne McCaffrey McCaffrey, Anne
McCaffrey, Anne McCaffrey, Anne
Anne McCaffrey ***blank****
Isaac Asimov Asimov, Isaac
Robert A Heinlein Heinlein, Robert A
Assuming the above data, and assuming that Calibre is set up so that author-sort defines the sort, then this list should have only one discrepancy, and that is a single one of the Anne McCaffrey items, the one where there is nothing defined in "author-Sort". With the above metadata, the Author list when sorted SHOULD look like this"
Anne McCaffrey
Asimov, Isaac
Heinlein, Robert A
McCaffrey, Anne
McCaffrey, Anne
McCaffrey, Anne
Where there is one entry for each entry in the underlying database, and where the record appears in the list as it is entered in the Author Sort field, in alphabetical order based on the initial character of that field. Only in the case of the author-sort field being empty should there be a discrepancy. **Actually, if I understand the way calibre works correctly, even in the above example the "anne mccaffrey" entry should automatically default to "McCaffrey, Anne" because that's the way the author-sort field populates when you check the box telling it to do so.
I do not know why in actuality, the records SORT on the first name, but appear in the list with the last name first. I can't think of any logical reason why that should be. Especially if the metadata is entered where the first name is in the field after the last name. So, "Brown, Dan" appearing in the list as "Brown, Dan" but sorting on the D, not the B, does not make sense to me.
|