[Koha-bugs] [Bug 31276] Report results are limited to 999, 999 no matter the actual number of results

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #1 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 138477
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138477&action=edit
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

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