starts_with - Filter operators

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

required

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

string

required

The prefix string to match. Returns rows where the field value begins with this substring.

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

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

starts_with - Filter operators

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples