sql_like - Filter operators

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

object[]

The string field to filter on, specified in the format view_name.field_name.

Hide string_field properties

string

required

The pattern to match using SQL LIKE syntax. Use % to match any sequence of characters and _ to match a single character.

boolean

default:"false"

When set to true, performs case-insensitive matching. Defaults to false (case-sensitive) if omitted.

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

starts_with - Filter operators

Templated filters

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

sql_like - Filter operators

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples