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

Filtering custom report by suspended enrolment status not working correctly

XMLWordPrintable

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE, MOODLE_402_STABLE
    • MDL-78761-401
    • MDL-78761-402
    • Hide
      1. Log in as admin
      2. Create two users (User 1 & User 2)
      3. Create a course
      4. Enrol both users as students in the course
      5. Edit the enrolment of User 2
        • Status: Suspended
      6. Navigate to Reports in user menu
      7. Create new report from Course participants report source
        • Include default setup: No
      8. Add the following columns to the report:
        • Course : Course fullname
        • User: Fullname
        • Enrolment: Status
        • Enrolment method: Name
      9. Confirm the Status column is empty for the Guest/Self enrolment method rows
      10. Confirm the Status column is correct for the Manual enrolment method rows
      11. Add Enrolment > Status condition to the report
      12. Set condition to Is equal to: Active and apply
      13. Confirm only User 1 and Admin User rows are present in the report
      14. Set condition to Is equal to: Suspected and apply
      15. Confirm only User 2 row is present in the report
      Show
      Log in as admin Create two users ( User 1 & User 2 ) Create a course Enrol both users as students in the course Edit the enrolment of User 2 Status: Suspended Navigate to Reports in user menu Create new report from Course participants report source Include default setup: No Add the following columns to the report: Course : Course fullname User: Fullname Enrolment: Status Enrolment method: Name Confirm the Status column is empty for the Guest/Self enrolment method rows Confirm the Status column is correct for the Manual enrolment method rows Add Enrolment > Status condition to the report Set condition to Is equal to: Active and apply Confirm only User 1 and Admin User rows are present in the report Set condition to Is equal to: Suspected and apply Confirm only User 2 row is present in the report

      Found this while looking at MDL-78755

      The Enrolment > Status condition/filter doesn't correctly determine Suspended case, because it always falls back to that value and missed the NULL case:

        1. confirm_condition_status_active.png
          confirm_condition_status_active.png
          381 kB
        2. confirm_condition_status_suspended.png
          confirm_condition_status_suspended.png
          372 kB
        3. confirm_users_have_right_status.png
          confirm_users_have_right_status.png
          318 kB
        4. create_users.png
          create_users.png
          278 kB
        5. MDL-78761.png
          MDL-78761.png
          232 kB
        6. Participants suspended.png
          Participants suspended.png
          65 kB

            pholden Paul Holden
            pholden Paul Holden
            Pedro Jordao Pedro Jordao
            David Carrillo David Carrillo
            Ron Carl Alfon Yu Ron Carl Alfon Yu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 43 minutes
                1h 43m

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