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 on the first post:
https://github.com/metabase/metabase/issues/3324
https://github.com/metabase/metabase/issues/5245
1 Like