CiviCRM Community Forums (archive)

Hi,
  I try to use Search Builder to build smart group.
  Unfortunately, I have some problem with Search Builder.  How can I search a custom field in profile?

For example:
Custom Data Fields:
Rating
Multiple choice values
1, 2, 3, 4 and 5
I added that custom data field to “Extra Info” Profile for MemberContact
I use Search Builder
Include contacts where
MemberContact
MemberContact:Rating
= 1

I cannot get correct result every time.  Sometime Civicrm gives me result with Rating = 2 or Rating 4.
What’s wrong with my setting?
Thanks,
R

For example:
Custom Data Fields:
Rating
Multiple choice values
1, 2 and 3 (see ss1.jpg and ss2.jpg)
I added that Rating field to  Membership profile (see ss3.jpg and ss4.jpg)

I have set a contact with Rating 1 and 3

I use Search Builder (see ss5.jpg)
I try to search by 1, tc, 3 and en (no result)
I also search by IS NOT NULL (it displays that contact)

Please help me.  Thank you!

R

rshun - Can you store multiple values in that custom field?  If so, I think you may need to use "LIKE" rather than "=".  That's a semi-bug, but you should be able to get it to work.  Let us know if it works!

Tech reason: when you can store multiple values, it puts a separator character into the database, which means you can't match on "=".