Drupal Views - Custom / Modded Sql

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 e

Solution 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 ...

Solution 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.

Solution 3:

Check out the Views modify query module.