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

Tasks log: improve class name filter

XMLWordPrintable

    • MOODLE_39_STABLE
    • MOODLE_401_STABLE
    • MDL-67685_Master
    • Hide

      Generate task log records:

      Using  attached script "create_task_log_records.php": 

      1. Copy the script to admin/cli
      2. Run the script: sudo -u www-data php admin/cli/create_task_log_records.php

      Testing:

      1. Go to "Site Administration > Server > Task logs": https://site}/admin/tasklogs.php
      2. Click "Fitlers" Button, (Right hand side, above the log table)
      3. Type "predict" in the "Class name" search box
      4. The "Auto-completion" should show "Predict models"
      5. Select the class name
      6. Apply filter
      7. The table should show only "Predict models" tasks
      Show
      Generate task log records: Using  attached script "create_task_log_records.php":  Copy the script to admin/cli Run the script: sudo -u www-data php admin/cli/create_task_log_records.php Testing: Go to "Site Administration > Server > Task logs": https:// site}/admin/tasklogs.php Click "Fitlers" Button, (Right hand side, above the log table) Type "predict" in the "Class name" search box The "Auto-completion" should show " Predict models " Select the class name Apply filter The table should show only " Predict models " tasks

      At default settings on a large site (eg remember 4 weeks or 20) doing a drill down into a class can be slow (many minutes)

      /admin/tasklogs.php?filter=assignfeedback_editpdf%5Ctask%5Cconvert_submissions

       

       This is because it's doing a massive sql like on the output of every task.

      Proposing to:

      1) unlock the session while it is running

      2) add a new filter which is just a direct join in the class (several minutes to, 20ms)

      ie new param:

      /admin/tasklogs.php?class=assignfeedback_editpdf%5Ctask%5Cconvert_submissions

       

       

        1. create_task_log_records.php
          2 kB
        2. MDL-67685_testing.webm
          3.80 MB
        3. modified_text_filter.png
          modified_text_filter.png
          131 kB
        4. Screenshot_2022-07-08 Moodle Master Administration Server Tasks Task logs.png
          Screenshot_2022-07-08 Moodle Master Administration Server Tasks Task logs.png
          8 kB
        5. Screenshot_2022-07-08 Moodle Master Administration Server Tasks Task logs(1).png
          Screenshot_2022-07-08 Moodle Master Administration Server Tasks Task logs(1).png
          10 kB

            Nguyen Nathan Nguyen
            brendanheywood Brendan Heywood
            Paul Holden Paul Holden
            Shamim Rezaie Shamim Rezaie
            Angelia Dela Cruz Angelia Dela Cruz
            Votes:
            4 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 4 hours, 10 minutes
                1d 4h 10m

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