CiviCRM Community Forums (archive)

Hello,
I read this post http://forum.civicrm.org/index.php/topic,3215.0.html  and attempted to reply, but was advised to start a new thread- so here it is. 

I have a custom field for Individuals in my DB called Type.  This field has 3 checkbox options.  Numerous check boxes can be checked for each individual- in other words, more than one box can be checked.  For this example we'll say that under the Type field, the checkbox options are:  red, blue, and green.  I have 5 records who just have red checked, 1 record with red and green checked, and 1 record with all 3 colors checked.  I also have 10 records who do not have any Type checked.

When I go into search builder, I would like to search for ALL individuals who have ANYTHING checked in the Type field.   I've found that this is an impossible search to run.  I set it up so that:

SEARCH FOR:

Individual-->Type = red
OR
Individual-->Type = blue
OR
Individual-->Type = green
OR
Individual-->Type = red AND
Individual-->Type = blue
OR
Individual-->Type = blue AND
Individual-->Type = green
OR
Individual-->Type = red AND
Individual-->Type = green
OR
Individual-->Type = red AND
Individual-->Type = blue AND
Individual-->Type = green

You'd think this search would work... I've included all the possible permutations!  But the ONLY records it finds are those with ONLY red checked.  I have 5 records with just red checked, 1 record with red and green, and 1 record with all 3 colors.  The search leaves out both records with multiples checked. 

I then ran a search to try and JUST find the 1 record with all 3 boxes checked:

Individual-->Type=red AND
Individual-->Type=blue AND
Individual-->Type=green

This didn't work either.  There seems to be, literally, no search that I can build that will return my record that has all 3 Type boxes checked.

Any ideas??  (It should be noted that, while I have a good user knowledge of CiviCRM, I am most definitely not a programmer and do not know MySQL or PHP).  I'm running CiviCRM 2.0.6.

Thanks Cynthia... it helps, but I looked at the links and it's a bunch of code... I am (unfortunately) not a programmer, and don't have a clue what to do with this code.  I guess I would need to hire someone to implement these updates... unless you have a different suggestion.

Hi,
I think that is a wise move on all counts.

Are you aware that the Civi team is about to release 2.2: http://wiki.civicrm.org/confluence/display/CRM/CiviCRM+v2.2.

You might want to wait for this as doing so will get you on the latest and greatest 

Good luck afrazier,
Cynthia