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

Remove restriction on Oracle filtering user/course longtext in custom reports

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 4.1
    • 4.1
    • Report builder
    • Oracle
    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • Hide
      1. Ensure you are testing on Oracle
      2. Log in as admin
      3. Create a new user
        • Description: My new user
      4. Create a new course
        • Full name: Course 1
      5. Create another new course
        • Full name: Course 2
        • Summary: My second course
      6. Navigate to Reports in user menu
      7. Create new report from Users report source (default setup)
      8. Add User > Description condition
        • Contains: new user
        • Apply
      9. Confirm only test user is displayed in report (admin should be excluded)
      10. Navigate to Reports in user menu
      11. Create new report from Courses report source (default setup)
      12. Add Course > Course summary condition
        • Contains: second course
        • Apply
      13. Confirm only second course is displayed in report (first course should be excluded)

      These changes are also covered by unit tests from MDL-73938

      Show
      Ensure you are testing on Oracle Log in as admin Create a new user Description: My new user Create a new course Full name: Course 1 Create another new course Full name: Course 2 Summary: My second course Navigate to Reports in user menu Create new report from Users report source (default setup) Add User > Description condition Contains: new user Apply Confirm only test user is displayed in report (admin should be excluded) Navigate to Reports in user menu Create new report from Courses report source (default setup) Add Course > Course summary condition Contains: second course Apply Confirm only second course is displayed in report (first course should be excluded) These changes are also covered by unit tests from MDL-73938

      See current comments in user / course entities:

      // Filtering isn't supported for LONGTEXT fields on Oracle.
      

      The reports that use these entities already have coverage of all filters/conditions (MDL-73938). We can use the same solution as here to achieve cross-DB compatibility

            pholden Paul Holden
            pholden Paul Holden
            Carlos Castillo Carlos Castillo
            Victor Déniz Falcón Victor Déniz Falcón
            John Edward Pedregosa John Edward Pedregosa
            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, 55 minutes
                3h 55m

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