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

Create "Notes" custom report source

    XMLWordPrintable

Details

    • 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

    Description

      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

      Attachments

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

        Issue Links

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Clockify

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