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