Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-11800

State = Null or Is Not Null doesn't work in Search Builder

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.2.7
    • Fix Version/s: 4.3.0
    • Component/s: CiviCRM Search
    • Labels:

      Description

      When using Search Builder to search on Individuals/Orgs where State is either Null or Not Null, the search yields no results. Other address fields work when doing this search in Search Builder (City and Postal Code work fine).

      This search is key for doing address clean-up and discovering which contacts have incomplete physical addresses.

      See attached screenshot. It's not an error message — just 0 results when there are contacts who match criteria and should be in results. Tested on the demo and this search doesn't work there either.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              reperry Robyn Perry
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: