[Koha-bugs] [Bug 23626] Add a system preference to limit the number of rows of data used in a chart when viewing report results

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

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

--- Comment #19 from Nick Clemens <nick at bywatersolutions.com> ---
Created attachment 93126
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93126&action=edit
Bug 23626: [alternate] Use svc/reports to fetch chart data

We have a method for getting json report data via svc, and this has a built in
limiter in the sysprefs. We can utilise this for our charts to avoid
passing all data in memory

To test:
1 - Write a report that can be charted, for example:
    SELECT RIGHT(barcode,2), COUNT(*)
    FROM items
    WHERE RIGHT(barcode,1) != <<Number>>
    GROUP BY RIGHT(barcode,2)
2 - Set the 'Cache expiry' to 1 for this report
3 - Run it and click 'Create chart' on results page
    Chart type: Pie
    x column RIGHT(barcode,2)
    Include all rows: UNCHECKED
4 - Note you get a nice pie chart
5 - Click 'Create chart', same except check 'Include all rows'
6 - Note you get a different pie
7 - Apply patch
8 - Repeat above - note that 'all rows' is now 'Fetch additional rows' and
notes the sys pref control
9 - Increase SvcMaxReportRows and note chart changes

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