How to apply Field Filter in where condition

While using a Field Filter in a simple select statement, below error is appearing.

(conn=36367) Unknown column ‘domains.name’ in ‘where clause’

Select Query:

select t1.col1, t2.col2 as domain from
t1
left join t2 on t2.col1 = t1.col1
where {{website}}

It doesn’t work with table aliases.

Yes. It’s quite limiting in that sense! I am also using Redash and it provides more flexibility in terms of Dashboard-level filters. One can create a filter drop-down list using “SELECT” sub-query there too.

One can create “Query Based Drop Down list” in Redash. I wonder if we can create something like this in Metabase!

@iamshubhamx
Neither aliases or SQL-based dropdown is possible currently. There’s requests open on both, so go and upvote by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/3324
https://github.com/metabase/metabase/issues/5245

1 Like