https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23626
--- Comment #19 from Nick Clemens <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
