My parameters aren't matching _parameter_value

[LookerExperts]

Knowledge Drop

Last tested: Jul 13, 2018
 

The field_name._parameter_value syntax brings in single quotes. So to match it, you need to use double quotes to include single quotes. If the parameter value is supposed to be foo , then you'd write something like:

sql: {% if test._parameter_value == "'foo'" %} 'SUCCESS' {% else %} 'FAIL' {% endif %} ;;

In label or description , you have to escape these double quotes with \ .

label: "{% if test._parameter_value == \"'foo'\" %} 'SUCCESS' {% else %} 'FAIL' {% endif %}"

This content is subject to limited support.