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

Custom user profile field filters are limited to users who have field defined

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 4.0
    • 4.0
    • Report builder
    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide
      1. Log in as Admin
      2. Navigate to Users > Accounts > User profile fields in site administration
      3. Create a new profile field of each type:
        • Checkbox
        • Drop-down menu
        • Text input
      4. Create a new user ensuring each of the custom profile fields is filled in
      5. Navigate to Reports > Report builder > Custom reports in site administration
      6. Create new report from Users report source. Untick "Include default setup"
      7. Add the Users > [PROFILE FIELD] column for each previous custom profile field created
      8. Open Conditions configuration in report editor
      9. Remove all current conditions
      10. Add the Users > [PROFILE FIELD] condition for each previous custom profile field created
      11. Under "User > Checkbox field"
            Set condition to "No"
            Confirm the report now shows users with the Checkbox unchecked PLUS those without it set
      12. Under "User > Drop-down menu field"
            Set the condition to "Is not equal to"
            Confirm the report now shows users with the Drop-down option distinct to the previous condition PLUS those without it set
      13. Under "User > Text input field"
            Set the condition to "Does not contain: [Some text]"
            Confirm the report now shows users with the Text input field does not contain previous condition PLUS those without it set
      14. Under "User > Text input field"
            Set the condition to "Is not equal to: [Some text]"
            Confirm the report now shows users with the Text input field not equal to the previous condition PLUS those without it set
      Show
      Log in as Admin Navigate to Users > Accounts > User profile fields in site administration Create a new profile field of each type: Checkbox Drop-down menu Text input Create a new user ensuring each of the custom profile fields is filled in Navigate to Reports > Report builder > Custom reports in site administration Create new report from Users report source. Untick " Include default setup " Add the Users > [PROFILE FIELD] column for each previous custom profile field created Open Conditions configuration in report editor Remove all current conditions Add the Users > [PROFILE FIELD] condition for each previous custom profile field created Under "User > Checkbox field "     Set condition to " No "     Confirm the report now shows users with the Checkbox unchecked PLUS those without it set Under "User > Drop-down menu field "     Set the condition to " Is not equal to "     Confirm the report now shows users with the Drop-down option distinct to the previous condition PLUS those without it set Under "User > Text input field "     Set the condition to " Does not contain: [Some text] "     Confirm the report now shows users with the Text input field does not contain previous condition PLUS those without it set Under "User > Text input field "     Set the condition to " Is not equal to: [Some text] "     Confirm the report now shows users with the Text input field not equal to the previous condition PLUS those without it set

    Description

      When conditions/filters are set in "Is not empty" or "Does not contain" or "Is not equal to" matches should include records who don't have the field set.

      Attachments

        Issue Links

          Activity

            People

              carlos.castillo@moodle.com Carlos Castillo
              carlos.castillo@moodle.com Carlos Castillo
              Paul Holden Paul Holden
              Jun Pataleta Jun Pataleta
              Gladys Basiana Gladys Basiana
              David Matamoros, Mikel Martín Corrales, Paul Holden
              Votes:
              0 Vote for this issue
              Watchers:
              5 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 - 6 hours, 55 minutes
                  6h 55m