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

Custom report source for course participants

    XMLWordPrintable

Details

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • MDL-74364-master
    • Hide
      1. Create 2 categories (Category 1..2)
      2. Create 2 courses (Course 1..2)
      3. Place Course 1 in Category 1
      4. Place Course 2 in Category 2
      5. Create 2 users (User 1..2)
      6. Enrol User 1 in Course 1
      7. Enrol User 2 in Course 2

       

      1. Login as admin
      2. Navigate to User menu > Reports
      3. Press New report
        1. Name: My course participants report
        2. Report source: Course participants
        3. Include default setup: Yes
      4. Press Save
      5. Add the following columns:
        1. Course category > Category name
        2. Course completion > Completed
      6. Add a new condition "Enrolment > Time created" and set it to "Not empty". Press "Apply" button.
      7. Confirm the following data is shown in the report:
      Course full name with link Method Full name with link Category name Completed
      Course 1 Manual enrolments User 1 Category 1 No
      Course 2 Manual enrolments User 2 Category 2 No
      1. Open Filters dropdown
      2. Add "User fullname" filter
      3. Press "Preview" button
      4. Press "Filters" button
      5. Set Full name filter to "Contains" "User 1" and press "Apply"
      6. Confirm only one row containing User 1 information is shown on the report
      Show
      Create 2 categories (Category 1..2) Create 2 courses (Course 1..2) Place Course 1 in Category 1 Place Course 2 in Category 2 Create 2 users (User 1..2) Enrol User 1 in Course 1 Enrol User 2 in Course 2   Login as admin Navigate to User menu > Reports Press New report Name: My course participants report Report source: Course participants Include default setup: Yes Press Save Add the following columns: Course category > Category name Course completion > Completed Add a new condition "Enrolment > Time created" and set it to "Not empty". Press "Apply" button. Confirm the following data is shown in the report: Course full name with link Method Full name with link Category name Completed Course 1 Manual enrolments User 1 Category 1 No Course 2 Manual enrolments User 2 Category 2 No Open Filters dropdown Add "User fullname" filter Press "Preview" button Press "Filters" button Set Full name filter to "Contains" "User 1" and press "Apply" Confirm only one row containing User 1 information is shown on the report

    Description

      The purpose of this new report source, is to allow flexible reports to be generated to allow for the reporting of course participants, enrolment, completion, and the last course access date.

      Columns

      1. Course category
        • <everything from course category entity>
      2. Course
        • <everything from course entity>
      3. Enrolment
        • Method
        • Time created
        • Time started
        • Time ended
        • Status
      4. User
        • <everything from user entity>
      5. Course completion
        • Completed
        • Progress
        • Time enrolled
        • Time started
        • Time completed
        • Time reaggregated
        • Days taking course
        • Days until completion
        • Grade
        • Required course grade
      6. Course access
        • Last access to course

      Conditions / Filters

      1. Course category
        • <everything from course category entity>
      2. Course
        • <everything from course entity>
      3. Enrolment
        • Method
        • Time created
        • Time started
        • Time ended
        • Status
      4. User
        • <everything from user entity>
      5. Course completion
        • Completed
        • Time completed
      6. Course access
        • Last access to course

      Attachments

        Issue Links

          caused a regression

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-77400 core_reportbuilder_retrieve_report WS fails when the Course Enrolment status column is used

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has a non-specific relationship to

          Improvement - An enhancement to an existing Moodle feature. MDL-75034 Move Report builder classes into /classes/reportbuilder/ namespace

          • Major - Major loss of function, incorrect output
          • Closed
          has been marked as being related by

          Improvement - An enhancement to an existing Moodle feature. MDL-73938 Implement thorough report source testing ("stress" tests)

          • Minor - Minor loss of function where workaround is possible
          • Closed
          Testing discovered

          Improvement - An enhancement to an existing Moodle feature. MDL-75640 Implement columns for completion criterias

          • Minor - Minor loss of function where workaround is possible
          • Closed
          will help resolve

          LMS - Ideas for Moodle LMS IDEA-35 Additional report builder reports

          • Medium -
          • Closed

          Activity

            People

              davidmatamoros David Matamoros
              pholden Paul Holden
              Paul Holden Paul Holden
              Ilya Tregubov Ilya Tregubov
              John Edward Pedregosa John Edward Pedregosa
              Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona), Carlos Castillo, David Matamoros, Mikel Martín Corrales, Paul Holden
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                28/Nov/22

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days, 13 minutes
                  3d 13m