Hi, is there a way to hardcode filter options? That is, instead of deriving the filter options from a table, can i just manually input what the selections are? I have a table that we inherited that’s highly denormalized and I want to be able to do a like (%%) search against a column. To put into context, my table has a column where the values are comma separated. Something like:
Find all rows with “blue”.
This is easy enough SQL to write but I can’t figure out how to configure a filter that would populate with all the distinct color options and then perform the like (%%) query.
Any help would be appreciated!