-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
3.5.6, 3.6, 3.7
-
None
-
3.6.0
-
MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE
The Report row limit (block_configurable_reports | reportlimit) setting in CR defines the maximum number of records that get displayed in a Custom SQL Report. If the query that you use returns more rows than that defined reportlimit number the report gets TRUNCATED at that number of rows.
So, if the reportlimit has been left at the default 5000 value and you create a custom SQL report that returns 6000 rows the report that Configurable Reports produces will be truncated at 5000 rows! When that truncation occurs CR needs to display a clear warning message indicating that the report has been truncated. This will reduce the risk of people producing custom SQL reports that have been truncated without them realizing that the truncation has occurred.
CR:
$plugin->version = 2019021500;
$plugin->release = '3.6.0';
Moodle:
$release = '3.5.2+ (Build: 20181027)';