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

1

I uploaded a CSV into MB. We are using a postgres database as our application database, so the CSV is uploaded as a table in there. I am currently running v0.55.22

When I attempt to create a simple SQL Query:

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

and use the field filter option (Dropdown filter) to map to a text field in my CSV, it throws the following error:

ERROR: operator does not exist: character varying = boolean Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 205

I've tried to type cast like so:

select *
from
mytable
[[where name = {{name}}::text]]

it just returns no results (even thought I know there should be!)

This seems to be an error from way back circa v0.3.x.x according to Github, but it also says its been resolved.

I don't see what the resolution is/was. Has the bug been re-introduced to MB?

2

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

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 :slight_smile: