I’m setting up a custom query to display the monthly totals based on some conditions (filters). The first part works well without the conditions, but as soon as I add the WHERE conditions, I get an error (see images). The GET parameters are used as filters and I was hoping to set-up a query with conditions similar to the “contains” condition in the standard wrappler query builder. I hope that makes sense.
So basically I have input fields on my webpage that are used to filter the data from the table. By the standard Wrappler query builder the condition would look something like “variable_name CONTAINS $_GET.variable_name”. How does this work with the custom query?