Event Dime

Filters on a text variable using LIKE '%%'

Events
When:
June 18, 2026 · 8:36 PM
Where:
STRING
Source:
Metabase Discussion

If you want to use the “ multiple values ” filter and want it to behave like “ string contains ”: [[AND EXISTS ( SELECT 1 FROM STRING_SPLIT(CONCAT_WS(',', filter_name, ''), ',') split_filter WHERE column_name LIKE '%' + split_filter.value + '%' AND split_filter.value <> '' )]] To see what your filter is actually passing in: SELECT CONCAT_WS(',', filter_name ) AS combined *I’m using SQL Server / MSSQL

Why this event appears here

This listing is shown because it is tied to the current city coverage and carries structured metadata that can be indexed and compared with other events.

  • City coverage

    STRING

  • Primary source

    Metabase Discussion

  • Categories

    Events