But no matter what filtering option I choose for the column, I can’t search for a value that’s contained in the array. It searches my varchar input directly against varchar[] which causes an error.
ERROR: operator does not exist: character varying[] = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 1930
Could we have a “contains” filter in the simple question view, or if it exists, how do we enable it?
P.S. I’ve labelled this is as a feature request, because it’s possible to do when changing to the SQL view, but we use Metabase precisely for those in the company that aren’t proficient with SQL.
Hi @dideler_rkki
Please post “Diagnostic Info” from Admin > Troubleshooting.
And which database are you querying?
Metabase does not support looking inside of JSON type columns (or similar, but I don’t know what database has “arrays” in varchar), so you would need to create a database view, so Metabase just sees a simple table with the array expanded into columns.
Hi, apologies. I'm not a programmer/engineer. can you explain this further? all i really need is to filter a column that is currently set as an array. i can't seem to do it.