checkbox search for "BOTH" rather than "OR"

You’re right, the fix is simple. Open bps-search.php, locate the line 138:

$sql .= 'AND ('. implode (' OR ', $like). ')';

and replace it with:

$sql .= 'AND ('. implode (' AND ', $like). ')';

Hi Andrea,

I am using AND to search a field that has 10 or so checkboxes.

The results are inaccurate and it seems that only the last checked checkbox is taken into account in the search results.

I can give you a link to my site to see this live.
Do you know what goes wrong?

@maelga and @aaronkine:

Unfortunately the “simple fix” I suggested is plain wrong. Since it looked so simple, I didn’t test it, but at a closer look it can’t work.

The real fix would be much more complex. If I find some time I’ll think about it, but I can’t promise anything. Sorry for the wrong answer!

@maelga and @aaronkine:

Well, probably I found a way. You could replace lines 136 to 138:

$like[] = $wpdb->prepare ("value = %s OR value LIKE %s", $value, $escaped);
}
$sql .= 'AND ('. implode (' OR ', $like). ')';

with

$like[] = $wpdb->prepare ("value LIKE %s", $escaped);
}
$sql .= 'AND ('. implode (' AND ', $like). ')';

Please let me know if that works for you!

@andrea: thank you so much for your fast response.
It works with my 3 dummy users. ??

Yep… works for me too! Thanks!

That’s great! I’m marking this topic as resolved now.

As of BP Profile Search 4.3, instead of editing your copy of the plugin you can add this line:

add_filter ('bps_field_checkbox_match_all', '__return_true');

to the file

wp-content/plugins/bp-custom.php

You can create the file if you don’t have it.

Thanks for the update Andrea