hi guys,
I try to use a field filter in a my question, but see that message,
Hi @wsca
You cannot use table aliases for the columns used in Field Filter, as noted in the documentation:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type
hi @flamber, okay …
I tried to create a subquery but a have a same message…
I think to resolve this problem I have to create a physical description column
@wsca
But you are not querying the table that you are including in the Field Type.
You would need to do something like:
select filial, desc_filial, saldo_lote from sch_unibi.estoque_lotes_bi
left join sch_unibi.filial_bi on ##what ever your joining ID would be##
[[where {{desc_filial}}]]
Note the schema is included. That is need for Oracle, when using Field Filter.