Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
drupal table profile_values only stores a bit for checkboxes. That means if you create a profile checkbox like "check here if you're super awesome" and then search for "awesome" you will not get a match.
This is easily fixed by adding (pf.title LIKE '%%%s%%' AND pf.type='checkbox' AND pv.value=1) to the where clauses on lines 55 and 60. Essentially searching by the field title for checkboxes and looking for checked items.
Might be worth adding to the module... or at least documenting somewhere for people that need to search checked profile fields.
Comments
Comment #1
James Marks CreditAttribution: James Marks commentedAdded advanced profile search capability including support for checkboxes in current development version.
Take a look at that version and see if it works for you.
James