[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