[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

--- Comment #10 from Sophie MEYNIEUX <sophie.meynieux at biblibre.com> ---
This patch fixes how the SQL request is built.
Union must be done before aggregation and not after, you have 2 results for
each value and not the sum of it.

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)

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