Having a dashboard filter that is not obliged to be used

@flamber i still don't really undertand the article. how can i input into my code

If you are using Field Filters then:

  • you cannot use table aliases
  • you cannot use the variable in other places than the WHERE-clause
  • you should not use column identifier and operator, since that is controlled by Metabase

If you cannot make Field Filters work for you, then don't use them. If you want to use them, then read the articles I have linked to many times - and read them one more time.

1 Like