How can I enter multiple filters into Parameters? (Community)

View the original community article here

Last tested: May 2020

Parameters only accept a single value.

In the event that you have a comma separated list like a,b,c in your filter, the parameter syntax {% parameter filter_field %} will bring that in as a single string "a,b,c" .

Therefore, if you have multiple values, use templated filters instead.

Using a filter field rather than a parameter field, you can enter multiple values and then use templated filters to build the proper SQL. For example, using the LookML:
{% condition filter_field %} other_field {% endcondition %}
while entering a , b , and c into filter_field in the UI, would generate the SQL:
other_field IN (a,b,c)