Author Topic: [SOLVED] Custom checkboxes search & reporting incorrect (Read 371 times)

clarkac · October 27, 2013, 05:14:02 am

I've set up a custom checkbox with 7 items - availability for each day of the week. So someone might check both 'Sunday' and 'Monday' while someone else will just check 'Sunday'. Problem is if I search for who is available Sunday - using Advanced or Builder then the only contact returned is where only Sunday was checked. Which is obviously incorrect.

But this isn't true for the built-in checkboxes - for example, communication preferences. If you search on these, it will return contacts correctly. Maybe because these are individual checkboxes, where my custom checkboxes are one set?

Is this a bug or am I misunderstanding something?

Donald Lobo · October 27, 2013, 08:21:53 am

if i had to guess, the civi search code does not account nicely for custom fields that are of type multi-select (i suspect multi-select came in after the search code)

this will need to be a code change / feature addition. Would help if someone can take a look and contribute a patch and/or sponsor a developer to do the needful. I suspect its a 10-20 hours fix

lobo

clarkac · October 28, 2013, 02:25:58 am

Hey, scrub this! I was wrong - Civi does correctly search these checkbox and multi-select boxes. I used 'RLIKE' in Search Builder and clicked 'Check to match ANY' in Advanced Search and got the right results. Sorry... (backs away with tail between his legs)... $:-\$

CiviCRM Community Forums (archive)

News:

Author Topic: [SOLVED] Custom checkboxes search & reporting incorrect (Read 371 times)

clarkac

[SOLVED] Custom checkboxes search & reporting incorrect

Donald Lobo

Re: Custom checkboxes search & reporting incorrect (I think)

clarkac

Re: Custom checkboxes search & reporting incorrect (I think)