Ben
Ben

Reputation: 101

Metabase Variable Filters for Postgres

I am running Metabase and PostgresSQL in Docker.

SQL query works fine. But its just Variable Filter in Metabase won't activate for my database.

select * from 
test_schema."Project" as pj 

where pj."Division" = {{"The Filter"}}

Any help here is really appreciated.

Thanks,

Upvotes: 0

Views: 576

Answers (1)

Ben
Ben

Reputation: 101

I got it fixed.

There is no double quotes needed in the variable filter. Also, it doesnt take spaces. Here is the working query:

test_schema."Project" as pj
where pj."Division" = {{Filter}}

Upvotes: 0

Related Questions