String-type attributes
String attributes support specific operators and conditions.
| Operators | Description | Example |
|---|---|---|
= |
Equal-to | customer_email_domain = 'example.com' |
!= |
Not-equal-to | customer_email_domain != 'example.com' |
IN |
Allows you to specify multiple values in a WHERE clause |
customer_language IN ('en-US', 'en-CA') |
LIKE |
Matches any value wildcard for string matching | customer_language LIKE 'en-%' |
CONTAINS |
Checks if value contains a substring | customer_language CONTAINS 'en-' |
Conditions accept UTF-8 characters and must be wrapped around single quotes
'.Conditions are case-sensitive and whitespaces are syntactically significant.
Single quotes within a condition must be escaped. For example,
'\'VIP\'').Conditions can be empty strings. The API verifies that the attribute exists and is an empty string.
All operators/functions returning a
String, such asCONCAT,SUBSTR,LOWER,UPPER, andTRUNCATE, are not supported for querying segments.