Details
-
Type:
Improvement
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Won't Do
-
Affects Version/s: 4.7.29
-
Fix Version/s: None
-
Component/s: CiviCRM Search
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:Yes
Description
After upgrading from 4.5.x to 4.7.29, Smart Groups don't work anymore for Postal Code based searches because 'greater then', 'less then', 'greater then/equal', 'less then/equal' operators are missing from the Search Builder, see file(s) attached:
Attachments
Activity
Based on the Zip Code Range custom search still working I have changed the priority.
@erikhommel Thanks for the clear feedback, we will now use the Custom Search 'Zip Code Range' as a workaround.
This is a bug which is fixed in 4.7.* where now postal_code is a string type attribute, reason only those operator which support string are present in select list. So I don't think it's a bug but expected behaviour. Hence closing this issue.
I expect this is because the postal_code is actually a string, so it does not provide the range searching.
Just checked the Custom Search 'Zip Code Range' (Search>Custom Searches>ZIp Code Range) and that still does work so perhaps this can be used as a workaround to build the Smart Groups perhaps?
Wouter H can you give that a try? If it works I would not classify this as a bug (as it makes sense to me to not use the > and < etc. for strings)