Bug 19206 - How should we sort 19xx when order is pubdate?
Summary: How should we sort 19xx when order is pubdate?
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-08-30 13:36 UTC by Marcel de Rooy
Modified: 2021-11-02 12:58 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

Note You need to log in before you can comment on or make changes to this bug.
Description Marcel de Rooy 2017-08-30 13:36:33 UTC
On bug 11046 I proposed to sort e.g. 19xx with 1900. This relates to the kohafield copyrightdate used to sort lists and in reports.
For search results, the sort on publication date depends on pubdate as indexed by Zebra. If we add uncertain years like 19xx or better 19uu in the MARC21 008, they will be sorted after 1999 (current situation).

We could add a "fix_008" in rebuild_zebra (just as a few other fixes already there) and replace 19uu by 1900 when indexing in order to get 19xx sorted with 1900.

What do you think ?
Comment 1 Katrin Fischer 2017-09-05 20:54:06 UTC
It's a hard one, I wonder how other systems might handle that. My initial feeling is that beginning (1900) seems better than end (1999) - but others might disagree.

From the documentatoin:
https://www.loc.gov/marc/bibliographic/bd008a.html
Determination of dates for 008/07-10 is made concurrently with the choice of code for 008/06. See the section above on 008/06 for examples and input conventions related to coded date information. The use of fill characters in 008/07-10, although possible, is discouraged since the data in Date 1 is used for retrieval and duplicate detection in many systems. When fill is used in 008/07-10, all four positions must contain the fill character.
Comment 2 Marcel de Rooy 2017-09-06 11:06:33 UTC
(In reply to Katrin Fischer from comment #1)
> https://www.loc.gov/marc/bibliographic/bd008a.html

From the same page:

008/06 s 
008/07-10 198u 
008/11-14 #### 
260 ##$aNew York :$bHaworth,$c[198-] 

008/06 s 
008/07-10 19uu 
008/11-14 ####

The character 'u' should normally be used for unknown years.
Comment 3 Marcel de Rooy 2021-11-02 12:58:17 UTC
Adding a See also to 24674 (about copyrightdate field) while this report deals with 008.