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

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major 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)';

            jleyva Juan Leyva
            libertymoodle Luis de Vasconcelos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.