Error using field filters

Get Help
1

@flamber
Hi Team,

I am now facing to an error using field filter.

When I did like
WHERE database_name.created_at = {{created_at}}
the error will be like Syntax error: Unexpected keyword BETWEEN at

And the I did like
WHERE {{created_at}}
the error will be like Unrecognized name: database_name

Are there any solution for this problem?

2

Hi @Kenzo
Post "Diagnostic Info" from Admin > Troubleshooting.
I don't know which database type you're using.
Read this: https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#field-filter-gotchas