Bug 31276: Report results are limited to 999,999 no matter the actual number of results
authorKyle Hall <kyle@bywatersolutions.com>
Mon, 1 Aug 2022 14:47:04 +0000 (10:47 -0400)
committerLucas Gass <lucas@bywatersolutions.com>
Fri, 30 Sep 2022 23:02:24 +0000 (23:02 +0000)
commitae71ac66f8933c50d27c3a9dffb1845f19b606f8
tree53ea7f2c6b9c360f73ddf80a05179f4c43de7349
parent92d541ddc4e3fe53c36cee836eb6c9b33f535694
Bug 31276: Report results are limited to 999,999 no matter the actual number of results

In Koha, any report that uses C4::Reports::Guided will be limited to 999,999 rows. This is causing problems for larger libraries where some reports may have over a million results.

Test Plan:
1) Create a report "SELECT * FROM borrowers" and run it, note the number
   of results
2) Apply this patch
3) Add the line `<report_results_limit>3</report_results_limit>`
   within the <config> block of your koha-conf.xml
4) Restart all the things!
5) Run the report, download the results as a CSV
6) Note your CSV only has 4 lines, the header and 3 patrons

Signed-off-by: Rachael Laritz <rachael.laritz@inlibro.com>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 5e29433bdc3a5ccd582ece6e2338c6e38e97c5d9)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
C4/Reports/Guided.pm
debian/templates/koha-conf-site.xml.in
etc/koha-conf.xml