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

Custom report source for course participants

XMLWordPrintable

    • 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

      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

        1. 1_MDL-74364_master.png
          1_MDL-74364_master.png
          15 kB
        2. 2_MDL-74364_master.png
          2_MDL-74364_master.png
          36 kB
        3. MDL-74364-enrol-join.diff
          3 kB
        4. Screenshot from 2022-08-04 08-59-11.png
          Screenshot from 2022-08-04 08-59-11.png
          15 kB

            davidcarrillo David Carrillo
            pholden Paul Holden
            Paul Holden Paul Holden
            Ilya Tregubov Ilya Tregubov
            John Edward Pedregosa John Edward Pedregosa
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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