How to set private variable in the 'where' block

1

Hello everyone,

I have 2 variable in the where block

example:
select * from user where email = {{email}} and createdBy = {{createdBy}};

How to set that createdBy is a private variable?
Because if I open this report in iFrame I see 2 input variables for email and createdBy, I wanna disable the createdBy column for the user.

Thank

2

Hi @uladzislau.vavilau.l
Use Embedding, which makes it possible to control the filter widgets:
https://www.metabase.com/docs/latest/administration-guide/13-embedding.html

3

it’s looks good.
Thank you so much