Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-7727

SQL reports that exceed the number of rows in 'Report row limit' get truncated

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.5.6, 3.6, 3.7
    • Fix Version/s: None
    • Labels:
      None
    • Plugin Version:
      3.6.0
    • Affected Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE

      Description

      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)';

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: