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