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

​
Syntax

<string_field>:
  ends_with: <suffix>

​
Properties

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

​
Examples

Matches: blobby@blobsrus.com, blob.ross@blobsrus.com, etc.
users.email:
  ends_with: @blobsrus.com
Matches: Everything but @gmail.com emails
users.email:
  not_ends_with: @gmail.com
Matches: blobsrus.com, BlobRoss.com, etc.
domains.url:
  ends_with: .com
  case_insensitive: true