Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-74140

Add debugging output for reports

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 4.1
    • 4.1
    • Report builder
    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • Hide
      1. Log in as admin
      2. Navigate to Development > Debugging in site administration
      3. Set Debug messages to Normal and save
      4. Navigate to Reports from user menu
      5. Create new report from Users report source
        • Ensure Include default setup is checked
      6. In editor, confirm that Debug info is not present beneath report
      7. Navigate to Development > Debugging in site administration
      8. Set Debug messages to Developer and save
      9. Navigate back to editor for the report you created
      10. Confirm presence of Debug info directly beneath report rows
      11. Expand Debug info
      12. Confirm presence of the following:
        • SQL query
        • SQL parameters
        • Execution time
      13. Add User > City/town column to report
      14. Confirm Debug info is reloaded with report content (u.city will be present in the SELECT statement)
      15. Press Preview
      16. Confirm Debug info is not present
      17. Close editor
      18. Press View report action for your report in Custom reports listing
      19. Confirm Debug info is not present
      20. Navigate to Reports > Report builder > Custom report settings in site administration
      21. Disable Custom reports live editing and save
      22. Navigate back to editor for the report you created
      23. Expand Debug info
      24. Confirm execution time value is not present (because we didn't execute a query)
      Show
      Log in as admin Navigate to Development > Debugging in site administration Set Debug messages to Normal and save Navigate to Reports from user menu Create new report from Users report source Ensure Include default setup is checked In editor, confirm that Debug info is not present beneath report Navigate to Development > Debugging in site administration Set Debug messages to Developer and save Navigate back to editor for the report you created Confirm presence of Debug info directly beneath report rows Expand Debug info Confirm presence of the following: SQL query SQL parameters Execution time Add User > City/town column to report Confirm Debug info is reloaded with report content ( u.city will be present in the SELECT statement) Press Preview Confirm Debug info is not present Close editor Press View report action for your report in Custom reports listing Confirm Debug info is not present Navigate to Reports > Report builder > Custom report settings in site administration Disable Custom reports live editing and save Navigate back to editor for the report you created Expand Debug info Confirm execution time value is not present (because we didn't execute a query)

      It would be nice if we could add a custom setting to output SQL queries on the UI for debugging purposes in Report Builder.

        1. master_1_MDL-74140.png
          master_1_MDL-74140.png
          46 kB
        2. master_2_MDL-74140.png
          master_2_MDL-74140.png
          37 kB
        3. master_3_MDL-74140.png
          master_3_MDL-74140.png
          61 kB
        4. master_4_MDL-74140.png
          master_4_MDL-74140.png
          38 kB

            pholden Paul Holden
            davidcarrillo David Carrillo
            David Carrillo David Carrillo
            Victor Déniz Falcón Victor Déniz Falcón
            John Edward Pedregosa John Edward Pedregosa
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 10 minutes
                2h 10m

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