Custom views with Solr search. I need a custom plugin to do a couple queries that neither Facets nor Views seem able to do out of the box. It's beyond my skillset and I'm having too hard a time trying to learn.
Essentially I need to be able to search and refine by two columns in a single table (custom compound field). At it's most simple, if you understand how to implement this query, and have it adaptable to multiple selects, let's talk: SELECT Entity_id FROM node__field_table
WHERE (field_one, field_two)
IN ( (8758, 8109),(8770, 8060),(8773, 7922) )
GROUP BY Entity_id
HAVING count(Entity_id) = 3