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

James Marks’s picture

Version: 6.x-1.1 » 6.x-2.x-dev
Assigned: Unassigned » James Marks
Status: Active » Fixed

Added 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

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.