Skip to main content
Filters string fields for values that contain a specified substring. Returns rows where the field value includes the specified substring. Can be used with case_insensitive to perform case-insensitive matching.

​
Syntax

<string_field>:
  contains: <substring>

​
Properties

​
string_field
string
required
The string field to filter on, specified in the format view_name.field_name.
​
contains
string
required
The substring to search for. Returns rows where the field value includes this substring.
​
case_insensitive
boolean
default:"false"
When set to true, performs case-insensitive matching. Defaults to false (case-sensitive) if omitted.

​
Examples

Matches: Blob premium, For premium blobs, etc.
products.description:
  contains: premium
Matches: Blobby Blobbington, The Great Blobby, etc.
users.name:
  contains: Blobby
Matches: error, ERROR, Error, etc.
messages.content:
  contains: error
  case_insensitive: true