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

Create "Course categories" custom report source

    XMLWordPrintable

Details

    • MOODLE_402_STABLE
    • MOODLE_403_STABLE
    • Hide

      Test setup

      1. Log in as admin
      2. Create a new user
      3. Navigate to Courses > Manage courses and categories in site administration
      4. Create a new category
        • ID number: CX101
      5. Create a course inside new category
      6. Assign new user the Manager role in new category
      7. Navigate to Users > Cohorts in site administration
      8. Create new cohort
        • Context: Category 1 (the default site category)

      Manual test

      1. Navigate to Reports in user menu
      2. Create new report from Course categories report source
        • Include default setup = Yes
      3. Confirm the following columns are present and correct:
        • Category name
        • Category ID number
        • Course count
      4. Expand Sorting in the editor
      5. Confirm Category name sorting is enabled
      6. Add Cohort > Name column
      7. Confirm name of cohort is reported for Category 1
      8. Add Role > Role name column
      9. Confirm name of role is reported for new category
      10. Add User > Full name column
      11. Confirm fullname of user is reported for test user in Manager role

      Note: testing is just a smoke test of the report source - the unit tests verify all the column/filters/content of the report

      Show
      Test setup Log in as admin Create a new user Navigate to Courses > Manage courses and categories in site administration Create a new category ID number: CX101 Create a course inside new category Assign new user the Manager role in new category Navigate to Users > Cohorts in site administration Create new cohort Context: Category 1 (the default site category) Manual test Navigate to Reports in user menu Create new report from Course categories report source Include default setup = Yes Confirm the following columns are present and correct: Category name Category ID number Course count Expand Sorting in the editor Confirm Category name sorting is enabled Add Cohort > Name column Confirm name of cohort is reported for Category 1 Add Role > Role name column Confirm name of role is reported for new category Add User > Full name column Confirm fullname of user is reported for test user in Manager role Note: testing is just a smoke test of the report source - the unit tests verify all the column/filters/content of the report

    Description

      This is similar to the original "Courses" report source from MDL-72280, but the primary table will be the categories table and it'll report on data specific to them

      Columns

      1. Course category
        • <everything from entity>
        • Course count
      2. Course
        • <everything from entity>
      3. Cohort
        • <everything from entity>
      4. Role (see MDL-76900)
        • <everything from entity>
      5. User
        • <everything from entity>

      Filters

      1. Course category
        • <everything from entity>
      2. Course
        • <everything from entity>
      3. Cohort
        • <everything from entity>
      4. Role
        • <everything from entity>
      5. User
        • <everything from entity>

      Conditions

      1. Course category
        • <everything from entity>
      2. Course
        • <everything from entity>
      3. Cohort
        • <everything from entity>
      4. Role
        • <everything from entity>
      5. User
        • <everything from entity>

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              pholden Paul Holden
              Andrew Lyons Andrew Lyons
              David Carrillo David Carrillo
              Ron Carl Alfon Yu Ron Carl Alfon Yu
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 35 minutes
                  3h 35m

                  Clockify

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