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

Create "Courses" custom report source

XMLWordPrintable

    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide

      Setup

      1. Create 2 categories (Category 1..2)
      2. Edit the description of Category 1 to include an image
      3. Create 3 courses (Course 1..3)
      4. Edit the course summary of Course 2 to include an image
      5. Place Course 1 in Category 1
      6. Place Course 2 & Course 3 in Category 2

      Test report source

      1. Login as admin
      2. Navigate to Reports > Report builder > Custom reports in site administration
      3. Press New report
        • Name: My course report
        • Report source: Courses
        • Include default setup: Yes
      4. Press Save
      5. Confirm the following default columns are present:
        • Category name
        • Course short name
        • Course full name
        • Course ID number
      6. Open Settings > Conditions
      7. Confirm the following default conditions are present:
        • Category name
      8. Open Settings > Filters
      9. Confirm the following default filters are present:
        • Category name
        • Course full name
        • Course ID number
      10. Close the Settings bar
      11. Confirm report content lists all courses previously created
      12. Add the following columns:
        • Course category > Description
        • Course > Course summary
      13. Drag & drop the Description column to after the Category name column
      14. Confirm Description column renders the image properly for Category 1
      15. Confirm Course summary column renders the image properly for Course 2
      16. Open Settings > Conditions
      17. Set Category name condition to Is equal to: Category 2 and press Apply
      18. Confirm only those courses in Category 2 are listed
      19. Press Preview
      20. Press Filters
      21. Set Course full name filter to Is equal to: Course 3 and press Apply
      22. Confirm only Course 3 is listed in the report
      Show
      Setup Create 2 categories (Category 1..2) Edit the description of Category 1 to include an image Create 3 courses (Course 1..3) Edit the course summary of Course 2 to include an image Place Course 1 in Category 1 Place Course 2 & Course 3 in Category 2 Test report source Login as admin Navigate to Reports > Report builder > Custom reports in site administration Press New report Name: My course report Report source: Courses Include default setup: Yes Press Save Confirm the following default columns are present: Category name Course short name Course full name Course ID number Open Settings > Conditions Confirm the following default conditions are present: Category name Open Settings > Filters Confirm the following default filters are present: Category name Course full name Course ID number Close the Settings bar Confirm report content lists all courses previously created Add the following columns: Course category > Description Course > Course summary Drag & drop the Description column to after the Category name column Confirm Description column renders the image properly for Category 1 Confirm Course summary column renders the image properly for Course 2 Open Settings > Conditions Set Category name condition to Is equal to: Category 2 and press Apply Confirm only those courses in Category 2 are listed Press Preview Press Filters Set Course full name filter to Is equal to: Course 3 and press Apply Confirm only Course 3 is listed in the report

      We have a courses entity from MDL-70794 - it will be straight forward to create a report source based off it (and also the best way to stress test it )

      Columns

      1. Course category
        • Name (default)
        • ID number
        • Description
      2. Course
        • Shortname (default)
        • Fullname (default)
        • ID number (default)
        • <everything else from entity>

      Filters

      1. Course category
        • Name (default) [select filter]
        • ID number [text filter]
      2. Course
        • Fullname (default)
        • ID number (default)
        • <everything else from entity>

      Conditions

      1. Course category
        • Name (default)
        • <everything else from entity>
      2. Course
        • <everything from entity>

        1. diffcourse_category.txt
          1 kB
        2. MDL-72280_Test Passed.png
          MDL-72280_Test Passed.png
          431 kB

            pholden Paul Holden
            pholden Paul Holden
            Carlos Castillo Carlos Castillo
            Ilya Tregubov Ilya Tregubov
            Gladys Basiana Gladys Basiana
            Votes:
            1 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 7 hours
                7h

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