Fix for Bug 6402, Lists sorted by year appear to be empty
authorOwen Leonard <oleonard@myacpl.org>
Tue, 24 May 2011 16:11:07 +0000 (12:11 -0400)
committerChris Cormack <chrisc@catalyst.net.nz>
Fri, 10 Jun 2011 00:14:52 +0000 (12:14 +1200)
commita13194f2cde980dc38efbf4e125754ee6449f91c
treec6f557767afa54e8ca061d9f1fabb7a8d8b485a9
parent577ce72e91dfafda270deb37d20c4ef1d573d493
Fix for Bug 6402, Lists sorted by year appear to be empty

If you create a list, populate it with titles, and then change the sort to
"year" it will appear as if your list is empty. The SQL in VirtualShelves.pm's
GetShelfContents tries to accept "year" as a sort by but 'year' is not a valid
column name.

The SQL pulls biblioitems.publicationyear. Changing this to
'biblioitems.publicationyear as year,'

Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
C4/VirtualShelves.pm