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

Create "Course categories" custom report source

XMLWordPrintable

    • 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

      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>

            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

              Created:
              Updated:
              Resolved:

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

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