Details
-
Type: New Feature
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.3.0
-
Fix Version/s: 4.3.0
-
Component/s: CiviCRM Search
-
Labels:None
Description
we need to extend mysql operators to allow either null or empty strings so we can so a valid empty search
IS EMPTY == IS NULL || value = ''
IS NOT EMPTY == IS NOT NULL && value != ''