Bug 13914 : Fix UNION in SQL request for reserves statistics
authorSophie Meynieux <sophie.meynieux@biblibre.com>
Wed, 10 Aug 2016 14:06:35 +0000 (16:06 +0200)
committerKyle M Hall <kyle@bywatersolutions.com>
Tue, 13 Sep 2016 17:12:38 +0000 (17:12 +0000)
commit7535b28f77269a3f0efecf9055477a345c9a63c4
tree9dd496d0a1cb7db1069776520312e1fae3348cba
parente330b6923aafa0c68b44eec6cacfbe1d8ff9d378
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@catalyst.net.nz>

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

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
reports/reserves_stats.pl