https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23626
Kyle M Hall <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #93126|0 |1 is obsolete| | --- Comment #23 from Kyle M Hall <[email protected]> --- Created attachment 93137 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=93137&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 Signed-off-by: Kyle M Hall <[email protected]> -- 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/
