Good morning everyone, can anyone help me? I have a query in the metabase with the "Account" field filter and I have 5 accounts in the dropdown list. What is happening is that the query is returning results for all "Accounts" even with the "Account" filter empty. I need that if the "Account" filter is empty, no data is returned or the query is not allowed, follow the SQL code:
Select , count()
From meu_dados_2024
Where
({{Account}} OR FALSE)
And {{Price}}
And Status = "Active"
Order By Price