View the original community article here
Last Tested: Jan 29, 2020
There are two main reasons that this happens:
- The values are not url-encoded (can be solved by using
{{value | url_encode}}
) - The values have special matches (advanced) filter expression characters in them. In some cases this can be fixed by using
filterable_value
instead of justvalue
, but this won't work for all special characters. If you want to guarantee that the value will be passed into the filter exactly as is, you should specify"type":"="
in thefilter_config
url parameter. The final URL should look something like this:/dashboards/[DASHBOARD_ID]?filter_config=%7B"Filter%20Name":%5B%7B"type":"%3D","values":%5B%7B"constant":"{{ value | url_encode }}"%7D,%7B%7D%5D,"id":9%7D%5D%7D
Additional resources:
https://help.looker.com/hc/en-us/articles/360001161308-How-to-Escape-Commas-in-Filters
https://docs.looker.com/reference/liquid-variables#liquid_variable_definitions
This content is subject to limited support.