[Koha-bugs] [Bug 14861] Accession date comparison does not work in advanced search

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14861

--- Comment #23 from David Cook <dcook at prosentient.com.au> ---
(In reply to Jonathan Druart from comment #22)
> Yep, if it works, let's do it for all date indexes :)

I suppose I should clarify this a bit...

In ccl.properties, we create the following mapping:

"st-date-normalized  4=5"

This associates a CCL qualifier name with a Bib-1 structure attribute.

Internally in Zebra, the Bib-1 attribute "4=5" is mapped to the Date "d"
register.
http://www.indexdata.com/zebra/doc/querymodel-zebra.html#querymodel-pqf-apt-mapping

If we search "biblio-zebra-indexdefs.xsl" for MARC21, we find that
"Date-of-acquisition" is actually the only index defined in the Date "d"
register. It's a little better for UNIMARC, as it also has "onloan" added to
the "d" register.

What that means is that "st-date-normalized" can really only be used for
"Date-of-acquisition" with MARC21/NORMARC, and "Date-of-acquisition" and
"onloan" for UNIMARC.

--

Of course, there are lots of other MARC fields where we store ISO formatted
dates, but we put them in the "w" register, so that they can be found using
"kw,wrdl" queries it seems.

We probably under-use the various registers available. The only index using the
"y" register is "pubdate" in MARC21. UNIMARC has a few more although I'm not
sure whether they're used correctly as I'm not familiar with the format. The
"y" register is only suitable for "YYYY" strings. The only way to access the
"y" register is by using "st-year" as well.

"st-numeric" accesses the "n" register which seems to be relied upon a lot in
Koha. 

--

In any case, I'll add a patch to add "r=o" to "st-date-normalized", even though
it will only really affect the advanced search for acquisition date (and any
CCL queries that are formed by hand). 

In the future, we could look at adding other indexes to the "d" register if
necessary...

-- 
You are receiving this mail because:
You are watching all bug changes.