[Koha] Wrong order wehen sorting public list by copyright year

[Katrin Fischer]

Hi Michael,

while the list result list for lists looks a lot like the catalog search
results, it's not working quite the same. Instead of using Zebra, it's
build with SQL. That means that the sorting does work differently as
well. My guess would be it's using biblio.copyrightdate. I would check
the contents of the columns and your Koha-to-MARC mappings for it. In
18.11 it's possible to map both 260$c and 264$c, but it's not done by
default.

Hope that helps,

Katrin

On 08.07.20 11:20, Michael Kuhn wrote:
> Hi
>
> We are working with Koha 18.11.05 on Debian GNU/Linux 8.
>
> In our library we found in the OPAC it is not possible to sort public
> lists correctly by copyright date.
>
> As far as I know sorting by copyright date would follow the content of
> MARC 008 position 7-10. But looking at an actual sorting we see the
> sorting is as follows
>
> 2018
> 2017
> 2016
> 2015
> 2015
> 2014
> 2014
> 2013
> 2011
> 2017 <-- here it starts getting wrong
> 2019
> 2018
> 2016
> 2018
> 2016
> ...
>
> Alle these records have correct content in MARC 008 and MARC 264$c.
>
> Strangely we found if a record has content in MARC 260$c and 264$c it
> changes the sort order - even if only MARC 008 should be relevant for
> the sort order.
>
> How can we achieve the correct sort order?
>
> Best wishes: Michael