There's also a problem with this when trying to use Views with the profile field. Views creates a sql query using the "where profile.value in ('list', 'of', 'options)" method to try to match select list profile values. Because of this, a value of "my, three, values" in the profile will not match if someone runs a filter against any of those values.

in other words:
where 'my,three,values' in ('my', 'three', 'values')
will always be false.

p.s. - i don't expect this to be fixed, just wanted to document it somewhere.

Comments

johnhanley’s picture

johnhanley commented

Yeah, this is due to the way Profile Checkboxes stores the checkbox values (hence the disclaimer on the project page).

You might try searching for a specific checkbox value... something equivalent in Views to:

SELECT * FROM profile_values WHERE value LIKE '%three%';
johnhanley’s picture

johnhanley commented
Status: Active » Closed (won't fix)