Works should include first publish date

[Edward Betts]

Work pages should show the first publish date of the work. This can be calculated by finding the earliest publish date of the editions linked to the work. I've written code to do this for works loaded to staging. It is running now.

[Anand Chitipothu (anandology)]

> Work pages should show the first publish date of the work. This can be
> calculated by finding the earliest publish date of the editions linked
> to the work. I've written code to do this for works loaded to staging.
> It is running now.

That won't be accurate because work.editions gives only 20 records
even if there are more.

[Edward Betts (edwardbetts)]

This code has finished running. Most works on staging should now have a first publish date.

[Edward Betts (edwardbetts)]

Whoops, good point Anand.

[Edward Betts (edwardbetts)]

I just checked my code, it isn't using the work.editions backreference. It is using a query to look for editions and increasing offset to step through the pages and get all the editions.

[Lance Arthur (lance-arthur)]

Still a problem on Upstream, i.e. "Through the Looking-Glass" shows a first published date of 1977.

http://upstream.openlibrary.org/works/OL151417W/Through_the_Looking-Glass

[Anand Chitipothu (anandology)]

added first_publish_year to Work class.

[George (george-archive)]

Re-opening. It needs a presence in the UI.

Lance - perhaps we should consider making the default sort by date (and not by whether you can read it, as it is currently). We should allow sort by date published too, in the DataTable.

[Lance Arthur (lance-arthur)]

Table now presents itself "unsorted" because default sort is by published year (though if the year is blank, those appear first). The table is sortable by date, online read, online buy or borrow. The table will also remember its state if you leave it by writing a small (4k-limited) cookie to the browser so the table will re-sort itself to the last known state if you leave and return to it.