]> git.koha-community.org Git - koha.git/commit
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 Nighswonger <chris.nighswonger@gmail.com>
Tue, 14 Jun 2011 00:57:11 +0000 (20:57 -0400)
commit33f2b99d2e830fb60f774f93717139153ba30c97
treebd24c68cfa7a7d4308554e613ebc4e28b4dd9350
parentde1c83f8bb52af4ed785e1476a493910ae9f6783
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>
(cherry picked from commit a13194f2cde980dc38efbf4e125754ee6449f91c)

Signed-off-by: Chris Nighswonger <chris.nighswonger@gmail.com>
C4/VirtualShelves.pm