#24 Author's Chronological bibliography is not chronological

[Robert Glowczynski]

This is the same as 'DisplayBug:20091 Shortfiction series entries displayed after non-series shortfiction' on http://www.isfdb.org/wiki/index.php/Open_Display_Bugs

From wiki:

The other problem with short fiction that appears in a series is that such stories are displayed out of chronological order in the short fiction list (this is true regardless of whether a series has books in it as well). See Michael Swanwick's summary biblio for an example, where the stories in his three (listed) short fiction series appear (in no apparent order) after the last non-series story (being "Lord Weary's Empire (2006)"). Jefe 16:36, 17 Jan 2007 (CST)

A related bug is that series names or numbering seems to mess up the Chronological Bibliography for novels [...]
Marc Kupper (talk)

The problem is clearly visible in Michael Swanwick's bibliography. In the 'Shortfiction' section, after 'Urdumheim (2007)' we jump back to 'The Bulls (1991)' and 'A is for Albany (1997)'.

The reason for this is that function SQLloadTitlesXBA (file common/SQLparsing.py), called by ch.cgi in bib.loadAllAuthorTitles(), does not have query for chronological display of titles - instead
select titles.* from titles,canonical_author where (canonical_author.author_id=%d and canonical_autho
r.title_id=titles.title_id and canonical_author.ca_status=1) and titles.title_parent=0 order by titles.title_seriesnum,titles
.title_copyright;"
is used, which sorts the data first by the number in series ('The Bulls' and 'A is for Albany' are 1st in two different series; 'The Bulls' is not displayed in Summary Bibliography because its series is shortfiction only).

[Robert Glowczynski]

Logged In: YES
user_id=792831
Originator: YES

The solution could be to use the chron field of the Bibliography class (file biblio.py). ch.cgi calls bib.setChronMode() (the only place it is jused) just before bib.loadAllAuthorTitles(), so we have bib.chron = 1 for chronological bibliography and = 0 (default) otherwise.

So I add another argument to SQLloadTitlesXBA and pass the value of bib.chron in loadAllAuthorTitles() (or 0 in other cases). And add another SQL query, similar to the default but with "order by titles.title_copyright;".
File Added: chronology.patch

[Robert Glowczynski]

Patch to fix the chronological bibliography

[Robert Glowczynski]

Logged In: YES
user_id=792831
Originator: YES

This is only the second part of the 'DisplayBug:20091 Shortfiction series entries displayed
after non-series shortfiction' wiki report, regarding Chronological bibliography. Another bug report has been filed for short fiction series displayed on Summary bibliography.

[MartyD]

This is fixed by the Series Display changes checked in 22-MAY-2009. Missing series sections have been added, which causes everything in a series to be displayed in an appropriate series location, avoiding having "orphans" appear at the end of their respective title-type lists due to being in a series that is not displayed.

[Ahasuerus]

Fixed in r2009-02.