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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jan 12 06:56:25 CET 2017


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

--- Comment #31 from David Cook <dcook at prosentient.com.au> ---
(In reply to Katrin Fischer from comment #30)
> Hm, tested this on a 3.22 database with the example from the test plan:
> 
> Search from advanced search by accession date:
> 2011-09-01 - 2011-09-30 
> 9461 results
> 
> Searched with SQL: 
> select distinct biblionumber from items where dateaccessioned between
> '2011-09-01' and '2011-09-30'
> 805 results
> 
> The date range search doesn't seem to work right.
> 
> The search for a single date seems to work correctly. You can also truncate
> with *.
> 
> Also filed this as a new bug report: bug 17815.

I'll comment there. Sounds interesting!

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


More information about the Koha-bugs mailing list