Error Using Variables

Lourival · April 23, 2019, 5:56pm

Dear, good afternoon!

Using the sample database (H2), I'm creating a question to display all people, where cities will be selected by the user. But Metabase is returning an error that I could not resolve. Can you help me. I'm using variables of type "Field Filter".

Query: select * from PEOPLE where CITY = {{city}}

flamber · April 23, 2019, 5:59pm

Hi @Lourival
When you’re using Field Filters, then your query should only include the variable and not the column.

SELECT * FROM "PEOPLE" WHERE {{variable}}

https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type

Lourival · April 23, 2019, 6:10pm

Hi @flamber

Thank you so much, my dear. I had not realized this remark.

Lourival · April 23, 2019, 6:37pm

But ... look at this other case. The ts_movimentacao column exists in the tb_registrar_assinatura_cliente table, and even then Metabase issues an error. See the attachment.

flamber · April 23, 2019, 6:45pm

@Lourival
You cannot use aliases, when using Field Filter.

Lourival · April 23, 2019, 7:01pm

Ok, very well.
Thanks!

Lourival · April 23, 2019, 7:33pm

@flamber, how to send you a private message? Looks like it’s blocked for you.

flamber · April 23, 2019, 7:39pm

I don’t provide private support, that’s why

Lourival · April 23, 2019, 7:46pm

Ok, vou postar a dúvida aqui no fórum...