[Bug 43436] New: Elasticsearch doesn't order publication dates with 'u' correctly
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 Bug ID: 43436 Summary: Elasticsearch doesn't order publication dates with 'u' correctly Initiative type: --- Sponsorship --- status: Product: Koha Version: 24.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org Target Milestone: --- In MARC21, but also in UNIMARC as was mentioned on Mattermost, sorting by publication date doesn't work correctly. We use date-of-publication for sorting. In MARC21 this contains the information from 008, 4-10 (Date 1). These dates are fixed on 4 characters and can contain u for unknown parts of the date: 0201 1999 07uu We noticed this while working on a project that has a lot of manuscripts that can date back to before 1000 and have some uncertainty. The 07uu will sort as 7, which puts it off by a few hundred years. I experimented with the "Call number" type in the configuration as that has a sort configuration of "numerical: false". The results appear to be much better then. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- "Call number" was a red hering it seems, but in general I think we might get better results with a non-numerical, alphabetic sorting here. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Using type "year" (that I only found now by Nick's hint) seems to work better. The default configuration uses Standary or type: "" for date-of-publication. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 Fridolin Somers <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |fridolin.somers@biblibre.co | |m -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 Nick Clemens (kidclamp) <nick@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |24807 CC| |nick@bywatersolutions.com --- Comment #3 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- See bug 24807 for discussion on the 'u' dates So do we just need to update the default mappings for date-of-publication to 'year'? Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24807 [Bug 24807] Add "year" type to improve sorting by publication date -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43436 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |Academy Summary|Elasticsearch doesn't order |Update Elasticsearch |publication dates with 'u' |default mappings to use |correctly |'year' type for | |date-of-publication --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Nick Clemens (kidclamp) from comment #3)
See bug 24807 for discussion on the 'u' dates
So do we just need to update the default mappings for date-of-publication to 'year'?
In my tests that seems to fix the issue nicely - so yes, I think that's the missing piece. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org