Bug 17203 - Searching by year does not work
Summary: Searching by year does not work
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Searching (show other bugs)
Version: 16.05
Hardware: All All
: P5 - low normal (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-08-26 13:36 UTC by Claudio Costales
Modified: 2017-06-14 22:12 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Search by date error explanation (84.78 KB, application/pdf)
2016-08-26 13:38 UTC, Claudio Costales
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Claudio Costales 2016-08-26 13:36:58 UTC
When searching by year in OPAC or Intranet no results are shown. All data is saved in copyright field in biblioitems table.

Tested in 16.05.02

See file attached.
Comment 1 Claudio Costales 2016-08-26 13:38:26 UTC
Created attachment 54929 [details]
Search by date error explanation
Comment 2 Katrin Fischer 2016-08-27 17:26:13 UTC
Hi Claudio, Koha is using 008 for this - so the copyrightdate column should not matter in this case. Are you using MARC21 or UNIMARC? Can you find out about the Zebra version you are using?
Comment 3 Claudio Costales 2016-08-27 18:02:32 UTC
008? Nobody is cataloguing 008 in this corner of the world... my God...

Using MARC21.

Zebra version: 4.2.30
Comment 4 Claudio Costales 2016-08-27 20:49:58 UTC
Thank you very much Katrin!
Comment 5 Katrin Fischer 2016-08-27 22:02:09 UTC
I have tried to verify: yr = pubdate = Date-of-publication
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=etc/zebradb/ccl.properties;h=3ec13637548817990250d9c6e8ae8f42ab843278;hb=53631f9ffdc86c1afbcc3108ac3ddf1f73fef40e

And only pubdate appears in the inded definition - and there only for 008. Try to catalog the first date in 008 to see if the search starts to work for you.
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=etc/zebradb/marc_defs/marc21/biblios/biblio-koha-indexdefs.xml;h=38f91a2103e98e4736ef2a919a89dc27aa7fa06c;hb=53631f9ffdc86c1afbcc3108ac3ddf1f73fef40e

260/264 are indexed in other indexes (one being copydate), but yr is the one used for the date range search.
Comment 6 Claudio Costales 2016-08-27 22:25:06 UTC
Katrin, cataloguing first date in 008 the search works fine!