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

[bugzilla-daemon at bugs.koha-community.org]

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

Chris Cormack <chris at bigballofwax.co.nz> changed:

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

--- Comment #11 from Chris Cormack <chris at bigballofwax.co.nz> ---
Created attachment 55173
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=55173&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>

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