Field Filtering after FROM statement

Get Help
1

Hi everyone,

I'm having doubts about whether I can use field filtering after FROM statements in metabase.
As an example, here is a simple request, and I'm already using field filtering to chose time intervals :

SELECT
date_trunc('day', signed_at)                                                           AS date,
AVG("value" / 10 ^ 18)                                                                 AS mean_volume
FROM chain_ethereum_mainnet.block_transactions
[[WHERE {{signed_at}}]]
GROUP BY date

but there are different "chains" in our database and I was to be able to use filtering to easily replace
chain_ethereum_mainnet to chain_arbitrum_mainnet across entire dashboards. If someone can help it would be awesome !

2

Hi @soispoke
Please read this article about Field Filters first - it should describe everything (and limitations):
https://www.metabase.com/learn/sql-questions/field-filters
But yes, WHERE-clauses comes after FROM-clauses.

3

Hi,

Thanks for your answer, I've read it and I do know that WHERE-clauses come after FROM-clauses, what I want to know is if there is anyway to make this work :

SELECT *
FROM  {{chain_ethereum_mainnet}}].block_transactions
4

@soispoke No, you cannot use any of the filters like that, since it would open up to SQL injections.
https://github.com/metabase/metabase/issues/4639 - upvote by clicking :+1: on the first post

Field Filters can only exist in WHERE-clause, while the other filter might be used elsewhere, it's only tested with the WHERE-clause.