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

Create "Groups" custom report source

XMLWordPrintable

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • Hide

      Create groups

      1. Log in as admin
      2. Create 3 new users (User 1 ... User 3)
      3. Create a new course
      4. Enrol all 3 users as students
      5. Navigate to course group settings
      6. Create 2 new groups:
        • Group 1 (members: User 1/User 2)
        • Group 2 (members: User 2/User 3)
        • Group 3 (no members)
      7. Create 1 new grouping:
        • My grouping (groups: Group 1/Group 2)

      Groups report

      1. Navigate to Reports in user menu
      2. Create new report from Groups report source
        • Ensure Include default setup is checked
      3. Confirm presence and accuracy of following report columns:
        • Course full name with link
        • Group name
        • User full name
      4. In report editor, add the following columns:
        • Grouping > Name
        • Group member > Time added
      5. Confirm grouping is shown in report for Group 1 and Group 2
      6. Confirm group member time added shows time each user was added to group
      7. Remove the column Group member > Time added
      8. Set User > Full name column aggregation to Comma separated values
      9. Confirm report shows for each group, a list of users in the Full name column
      10. Open report conditions
      11. Set Group > Name to the following:
        • Is equal to: Group 2
      12. Apply conditions
      13. Confirm only Group 2 is listed in the report

      Course participants report

      1. Navigate to Reports in user menu
      2. Create new report from Course participants report source
        • Ensure Include default setup is checked
      3. In report editor, add the following columns:
        • Group > Name
      4. Confirm groups are shown for each participant
      5. Set Group > Name column aggregation to Comma separated values
      6. Confirm report shows for each participant, a list of groups in the Name column
      7. Open conditions, add Group > Name as follows:
        • Is equal to: Group 2
      8. Apply conditions
      9. Confirm only Group 2 participants are listed in the report
      Show
      Create groups Log in as admin Create 3 new users ( User 1 ... User 3 ) Create a new course Enrol all 3 users as students Navigate to course group settings Create 2 new groups: Group 1 (members: User 1/User 2) Group 2 (members: User 2/User 3) Group 3 (no members) Create 1 new grouping: My grouping (groups: Group 1/Group 2) Groups report Navigate to Reports in user menu Create new report from Groups report source Ensure Include default setup is checked Confirm presence and accuracy of following report columns: Course full name with link Group name User full name In report editor, add the following columns: Grouping > Name Group member > Time added Confirm grouping is shown in report for Group 1 and Group 2 Confirm group member time added shows time each user was added to group Remove the column Group member > Time added Set User > Full name column aggregation to Comma separated values Confirm report shows for each group, a list of users in the Full name column Open report conditions Set Group > Name to the following: Is equal to: Group 2 Apply conditions Confirm only Group 2 is listed in the report Course participants report Navigate to Reports in user menu Create new report from Course participants report source Ensure Include default setup is checked In report editor, add the following columns: Group > Name Confirm groups are shown for each participant Set Group > Name column aggregation to Comma separated values Confirm report shows for each participant, a list of groups in the Name column Open conditions, add Group > Name as follows: Is equal to: Group 2 Apply conditions Confirm only Group 2 participants are listed in the report

      The purpose of this report source is to allow flexible reporting on groups, members and groupings across the site (and introduce related entities that will be required for further course reporting)

      Columns

      1. Course
        • <everything from course entity>
      2. Group
        • Name
        • ID number
        • Description
        • Enrolment key
        • Picture
        • Time created
        • Time modified
      3. Grouping
        • Name
        • ID number
        • Description
        • Time created
        • Time modified
      4. Group member
        • Time added
        • Component
      5. User
        • <everything from user entity>

      Conditions/filters

      1. Course
        • <everything from course entity>
      2. Group
        • Name
        • ID number
        • Time created
      3. Grouping
        • Name
        • ID number
        • Time created
      4. Group member
        • Time added
      5. User
        • <everything from user entity>

        1. course_participants_MDL-75349.mp4
          2.26 MB
        2. group_report_MDL-75349.mp4
          2.53 MB

            pholden Paul Holden
            pholden Paul Holden
            David Carrillo David Carrillo
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            John Edward Pedregosa John Edward Pedregosa
            Votes:
            2 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 - 6 hours, 25 minutes
                6h 25m

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