[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
bugzilla-daemon at bugs.koha-community.org
Fri Aug 12 15:34:45 CEST 2022
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31276
Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #138915|0 |1
is obsolete| |
--- Comment #5 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 139052
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=139052&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
Signed-off-by: Rachael Laritz <rachael.laritz at inlibro.com>
Signed-off-by: Martin Renvoize <martin.renvoize at ptfs-europe.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list