[Koha-bugs] [Bug 12082] New: hold statistics wizard can produce misleading results
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Apr 15 02:28:19 CEST 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12082
Bug ID: 12082
Summary: hold statistics wizard can produce misleading results
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Reports
Assignee: gmcharlt at gmail.com
Reporter: gmcharlt at gmail.com
QA Contact: testopia at bugs.koha-community.org
The hold statistics wizards can produce or misleading incorrect results. Here
are at least two circumstances:
Case 1:
- hold status = active column
- hold date = active row, with date range 3/1/2014-3/2/2014
- holding library: not blank
- home library: not blank
Because the filters get applied even if they're not selected as the row or
column, in this case the report doesn't count any bib-level requests that are
not yet filled or which were cancelled. This is because the home/holding
library comes into play only if there is an item number set, which doesn't
happen for bib-level requests until the hold is captured.
This can result in a hard-to-explain situation where running a report on the
number of holds in the previous month can change over time as holds placed
towards the end of the month get filled.
Case 2:
- hold status = active column
- hold date = active row, with date range 3/1/2014-3/2/2014
- holding library blank
- home library blank
If there happens to be a case where, for a given date, the number of requests
of a given status is the same in both reserves and old_reserves, the fact that
a "UNION" is used rather than a "UNION ALL" means that only one set is counted.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list