Skip to main content
Filters string fields using SQL LIKE pattern matching with wildcards. Returns rows where the field value matches the specified pattern using SQL LIKE syntax. Can be used with case_insensitive to perform case-insensitive matching.
To create this filter in a workbook, use the is like operator.

​
Syntax

<string_field>:
  sql_like: <pattern>

​
Properties

​
string_field
object[]
The string field to filter on, specified in the format view_name.field_name.

​
Examples

Matches names containing both 'Adel' and 'Vargas' in that order
users.name:
  sql_like: '%Adel%Vargas%'
Matches products starting with 'prod' and ending with any 3 characters
products.sku:
  sql_like: 'prod___'
Matches email addresses from gmail.com (case-insensitive)
users.email:
  sql_like: '%@gmail.com'
  case_insensitive: true