Hello, I’m totally new to the metabase, and I’m not getting my variables and filters working together. The FULL_NAME column is a list of names I’d like to use as a filter for my two questions on the dashboard.
Your problem is in the last line of your SQL. It should be
This is because field filters, in contrast to “normal” variables, insert a SQL snippet rather than just a value. So in your case, that variable is being replaced with the snippet
J.FULL_NAME=(whatever the selected value is). This is so that you can map the variable to a specific field, and so that Metabase can present richer filter widgets that let your users select operators other than
=, like “starts with” etc.
I hope that helps!