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

--- Comment #10 from Sophie MEYNIEUX <sophie.meyni...@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.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to