]> git.koha-community.org Git - koha.git/commit
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)
committerArthur Suzuki <arthur.suzuki@biblibre.com>
Wed, 12 Oct 2022 14:34:39 +0000 (16:34 +0200)
commit47ebd758c7354c26b57929665a703ecc690d8656
tree77f214c00b076b2630c523e0e6b3ddfe9fadafb3
parente86a36c1504ecdfc3bf55eed0c913d7158da4ba0
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>
(cherry picked from commit ae71ac66f8933c50d27c3a9dffb1845f19b606f8)
Signed-off-by: Arthur Suzuki <arthur.suzuki@biblibre.com>
C4/Reports/Guided.pm
debian/templates/koha-conf-site.xml.in
etc/koha-conf.xml