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
    • 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. Participants suspended.png
          65 kB
          Paul Holden
        2. confirm_condition_status_active.png
          381 kB
          Pedro Jordao
        3. confirm_condition_status_suspended.png
          372 kB
          Pedro Jordao
        4. confirm_users_have_right_status.png
          318 kB
          Pedro Jordao
        5. create_users.png
          278 kB
          Pedro Jordao
        6. MDL-78761.png
          232 kB
          Ron Carl Alfon Yu

            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.