Using Field Filters on CSV's ERROR: operator does not exist: character varying = boolean

[rossi45]

I've been digging further into this issue and found a related question that solved my problem:

ERROR: operator does not exist

I'm getting this error on a signed embed: ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 81 I checked github and saw there is an issue related to this message, but I couldn't understand how it applies to me. I'm using a sqlite database and the public version of the dashboard works perfectly: https://metabase.gregory-ms.com/public/dashboard/7455fc3e-c775-4958-9046-1…

For me, I was not setting my query correctly within the where clause. it should have been set to:

select *
from
mytable
[[where  {{name}} ]]

Please review the help documentation outlined in the related question. It has the answers