Drupal Views - Custom / Modded SQL

Question

I am having an issue with the "Profile Checkboxes" module which stores custom profile fields comma separated.

The issue is if I create a view to filter by a value. The SQL result ends up being something like this:

...AND (profile_values_profile_interests.value in ('Business and Investment'))...

Which will not return any data since the value is stored like this:

"Business and Investment, Case Law, Labor Law, Tax Law"

I just need to adjust the SQL so that it is making sure the field contains the selected value

Is there anything I can do to adjust this?

Answer 1

For a 'quick hack' solution, you could try implementing hook_views_query_alter(&$view, &$query) in a custom module, check $view->name (and eventually also $view->current_display) to ensure you are dealing with the right view/display, and then manipulate $query as needed.

---

EDIT: Looks like the underlying problem has been addressed by the module maintainer in the meantime - see John's answer ...

Answer 2

I'm the creator and maintainer of Profile Checkboxes and thought you might be interested to know that the new version of the module now stores the values as serialized and includes Views support. The feature is available in the current release version.

Answer 3

Check out the Views modify query module.