[Koha-bugs] [Bug 13914] The holds statistics report returns random data

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Sep 13 11:09:28 CEST 2016


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

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #55173|0                           |1
        is obsolete|                            |

--- Comment #12 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
Created attachment 55521
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=55521&action=edit
Bug 13914 : Fix UNION in SQL request for reserves statistics

Test plan
=========
On Reports > reservations, select all statuses as line, pickup library as
column (empty) and a range of hold date. Keep the results
Run the same reports but with statuses as column and pickup library as line
You should get the same results on another display.

* Without patch, if you've got representative data, most of the time you can
observe significant differences between both results

* With the patch, results are always the same (and right if you request
directly your database)

Signed-off-by: Chris Cormack <chrisc at catalyst.net.nz>

Signed-off-by: Jonathan Druart <jonathan.druart at bugs.koha-community.org>

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


More information about the Koha-bugs mailing list