I made a dashboard and add a filter on boolean field (named ‘is_day’). When I typed True or TRUE or true in this field, it was shown this error in the original question:
“ERROR: operator does not exist: boolean = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 713”
I saw ‘view the sql’ and find this converting from my field filter:
is_day = ‘TRUE’
I explored in column’s type setting and didn’t find type for boolean.
Metabase version: 0.36.2