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.
Created attachment 4245 [details] [review]
The SQL pulls biblioitems.publicationyear. Changing this to 'biblioitems.publicationyear as year,'.
Created attachment 4254 [details] [review]
Signed off patch
Easy to test fix, pushed please test on master
This is fixed as far as making the list display, but at least with my data the sort doesn't actually work: It's trying to sort by biblioitems.publicationyear. biblioitems.publicationyear is empty because in the default MARC21 mapping publicationyear isn't mapped to anything.
I have uploaded a possible fix for Owen's bug to bug8323