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

Create "Courses" custom report source

    XMLWordPrintable

Details

    • 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

    Description

      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>

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:
                19/Apr/22

                Time Tracking

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