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

Custom report source for course participants

    XMLWordPrintable

Details

    • 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

          has a non-specific relationship to

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-75034 Move Report builder classes into /classes/reportbuilder/ namespace

          • Minor - Minor loss of function where workaround is possible
          • Open
          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
          • Development in progress

          Activity

            People

              davidmatamoros David Matamoros
              pholden Paul Holden
              Paul Holden Paul Holden
              Ilya Tregubov Ilya Tregubov
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Laurent David, Raquel Ortega, Sara Arjona (@sarjona), Carlos Castillo, David Matamoros, Mikel Martín Corrales, Paul Holden
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 5 hours, 31 minutes
                  2d 5h 31m