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

​
Syntax

<string_field>:
  starts_with: <prefix>

​
Properties

​
string_field
string
required
The string field to filter on, specified in the format view_name.field_name.
​
starts_with
string
required
The prefix string to match. Returns rows where the field value begins with this substring.
​
case_insensitive
boolean
When set to true, performs case-insensitive matching. Defaults to false (case-sensitive) if omitted.

​
Examples

Matches: blobby@blobsrus.com, blob.ross@blobross.com
users.email:
  starts_with: blob
Matches: BLOB-CAKE, BLOB-cookie, etc.
products.name:
  starts_with: BLOB-
Matches: Blobby, blobinator, etc.
customers.name:
  starts_with: Blob
  case_insensitive: true