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

Create "Notes" custom report source

XMLWordPrintable

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • Hide

      Create some notes

      1. Log in as admin
      2. Create a new user
      3. Create a course
      4. Enrol user in course as student
      5. Click on users name in participants list to view course profile
      6. Press Miscellaneous > Notes
      7. Add a new course note for the user
        • Fill in Content field
        • Context: course
      8. Add a new personal note for the user
        • Fill in Content field
        • Context: personal

      Create report

      1. Navigate to Reports in user menu
      2. Create new report from Notes report source
        • Include default setup
      3. Confirm the following columns are present and correct for each note:
        • Recipient full name
        • Context
        • Course full name
        • Content
      4. Add Author > Full name column
      5. Confirm column shows the name of the note author
      6. Open report conditions
      7. Set Recipient > Full name condition:
        • Does not contain: [First name of test user]
        • Apply
      8. Confirm report shows Nothing to display
      9. Change condition to Contains and apply
      10. Confirm report shows test user notes
      11. Set Course > Course full name condition:
        • Is equal to: [Name of course]
        • Apply
      12. Confirm report shows only the course note from that course
      13. Add Author > Full name condition
        • Does not contain: Admin
        • Apply
      14. Confirm report shows Nothing to display
      15. Change condition to Contains and apply
      16. Confirm report shows only the course note authored by admin
      Show
      Create some notes Log in as admin Create a new user Create a course Enrol user in course as student Click on users name in participants list to view course profile Press Miscellaneous > Notes Add a new course note for the user Fill in Content field Context: course Add a new personal note for the user Fill in Content field Context: personal Create report Navigate to Reports in user menu Create new report from Notes report source Include default setup Confirm the following columns are present and correct for each note: Recipient full name Context Course full name Content Add Author > Full name column Confirm column shows the name of the note author Open report conditions Set Recipient > Full name condition: Does not contain: [First name of test user] Apply Confirm report shows Nothing to display Change condition to Contains and apply Confirm report shows test user notes Set Course > Course full name condition: Is equal to: [Name of course] Apply Confirm report shows only the course note from that course Add Author > Full name condition Does not contain: Admin Apply Confirm report shows Nothing to display Change condition to Contains and apply Confirm report shows only the course note authored by admin

      The purpose of this report source is to allow flexible reporting on site, personal and course related notes

      Columns

      1. Note
        • Content
        • Context
        • Time created
        • Time modified
      2. Recipient
        • <everything from user entity>
      3. Author
        • <everything from user entity>
      4. Course
        • <everything from course entity>

      Conditions/filters

      1. Note
        • Content
        • Context
        • Time created
        • Time modified
      2. Recipient
        • <everything from user entity>
      3. Author
        • <everything from user entity>
      4. Course
        • <everything from course entity>

      This will also demonstrate the pattern of using the same entity (user) multiple times in a single report (once for the note author, once for the recipient) and provide API improvements for the same

      I also found MDL-75152 while working on this, but that can be fixed separately to this one as it's a pre-existing bug

        1. 1_MDL-75165.png
          1_MDL-75165.png
          69 kB
        2. 2_MDL-75165.png
          2_MDL-75165.png
          91 kB
        3. 3_MDL-75165.png
          3_MDL-75165.png
          87 kB
        4. 4_MDL-75165.png
          4_MDL-75165.png
          94 kB
        5. 5_MDL-75165.png
          5_MDL-75165.png
          98 kB
        6. 6_MDL-75165.png
          6_MDL-75165.png
          99 kB
        7. 7_MDL-75165.png
          7_MDL-75165.png
          101 kB

            pholden Paul Holden
            pholden Paul Holden
            Carlos Castillo Carlos Castillo
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            John Edward Pedregosa John Edward Pedregosa
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 2 hours, 20 minutes
                1d 2h 20m

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