CiviCRM Community Forums (archive)

Hi -

When I use a Search Profile to find all contacts where a specific Yes/No field equals "No", the results I get are all those where the field is empty, as well as all those where the value is "No."

However, when I use Search Builder to count my contacts where that same Yes/No field is "No" ("0"), I only get the actual "No" contacts (54), as opposed to when I use it to count all nulls in that field, getting a much larger number (1754).

Thus, people using my Search Profile to find contacts where the value of the Yes/No fields is "No" are getting huge false negative results.

Is there a simple fix for this?  I'm guessing other newbies have tripped up on this, and that I must be overlooking something.  Thanks.

~ Rob