[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

Rachael <rachael.laritz at inlibro.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #138477|0                           |1
        is obsolete|                            |

--- Comment #4 from Rachael <rachael.laritz at inlibro.com> ---
Created attachment 138915
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=138915&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>

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