[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 #2 from Barton Chittenden <barton at bywatersolutions.com> ---
(In reply to David Cook from comment #1)
> Hey Barton, I can explain the cause (and solution).
> 
> Check out "ccl.properties":
> 
> Date-of-publication 1=31 r=r
> yr Date-of-publication
> pubdate Date-of-publication
> 
> Date-of-acquisition 1=32
> acqdate Date-of-acquisition
> 
> st-numeric  4=109 r=o
> st-name-normalized  4=101
> 
> If you look at the Zebra docs, you'll see that r=o and r=r are special
> attributes for doing range searches
> (http://www.indexdata.com/yaz/doc/tools.html). 
> 
> I wrote about this last year on
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12897 but I didn't
> go any further with it as it would be nice to make some more logical changes
> across the board... but feel free to make a patch to fix this particular
> case.
> 
> --
> 
> Locally, I've done the following to solve this problem:
> 
> Date-of-acquisition 1=Date-of-acquisition r=o
> acqdate Date-of-acquisition

Ok, this is from my ccl.properties:

Date-of-acquisition 1=32
Date-of-acquisition 1=Date-of-acquisition r=o
acqdate Date-of-acquisition

Given an item where acqdate is 2011-09-07,

  search.pl?idx=acqdate%2Cst-date-normalized&q=2011-09-07

works, but querying the entire month from 2011-09-01 to 2011-09-30 does not:

  search.pl?idx=acqdate%2Cst-date-normalized&q="2011-09-01+-+2011-09-30"

Returns no results.

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