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
// 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