| Name | Type | Description |
|---|
| AND | OrganizationalContactFilter | A field that checks if all filters in the list apply If the list is empty, this filter applies to all objects. |
| OR | OrganizationalContactFilter | A field that checks if any of the filters in the list apply. If the list is empty, this filter applies to no objects. Note that only the items in the list or-combined; this complete OR field is and-combined with outer fields in the parent filter type. |
| email | String | Checks if email equals a specified string, case-sensitively. If an index exists on email, it can be used. See also like for a case-insensitive filter. The email address of the contact |
| email_contains | String | Checks if email contains a specified string, case-sensitively. The email address of the contact |
| email_ends_with | String | Checks if email ends with a specified string, case-sensitively. The email address of the contact |
| email_gt | String | Checks if email is greater than a specified value. The email address of the contact |
| email_gte | String | Checks if email is greater or equal a specified value. The email address of the contact |
| email_in | String | Checks if email is equal to one of the specified values. The email address of the contact |
| email_like | String | Matches email against a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
If an index exists on email, it can be used for the literal prefix (the part until the first placeholder). The email address of the contact |
| email_lt | String | Checks if email is less than a specified value. The email address of the contact |
| email_lte | String | Checks if email is less or equal a specified value. The email address of the contact |
| email_not | String | Checks if email does not equal a specified string, case-sensitively. The email address of the contact |
| email_not_contains | String | Checks if email does not contain a specified string, case-sensitively. The email address of the contact |
| email_not_ends_with | String | Checks if email does not end with a specified string, case-sensitively. The email address of the contact |
| email_not_in | String | Checks if email is not equal to one of the specified values. The email address of the contact |
| email_not_like | String | Checks if email does not match a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
The email address of the contact |
| email_not_starts_with | String | Checks if email does not start with a specified string, case-sensitively. Never uses an index. Consider using not_like (with the % placeholder) for a case-insensitive filter that can use an index. The email address of the contact |
| email_starts_with | String | Checks if email starts with a specified string, case-sensitively. Never uses an index. Consider using like (with the % placeholder) for a case-insensitive filter that can use an index. The email address of the contact |
| name | String | Checks if name equals a specified string, case-sensitively. If an index exists on name, it can be used. See also like for a case-insensitive filter. The name of the contact |
| name_contains | String | Checks if name contains a specified string, case-sensitively. The name of the contact |
| name_ends_with | String | Checks if name ends with a specified string, case-sensitively. The name of the contact |
| name_gt | String | Checks if name is greater than a specified value. The name of the contact |
| name_gte | String | Checks if name is greater or equal a specified value. The name of the contact |
| name_in | String | Checks if name is equal to one of the specified values. The name of the contact |
| name_like | String | Matches name against a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
If an index exists on name, it can be used for the literal prefix (the part until the first placeholder). The name of the contact |
| name_lt | String | Checks if name is less than a specified value. The name of the contact |
| name_lte | String | Checks if name is less or equal a specified value. The name of the contact |
| name_not | String | Checks if name does not equal a specified string, case-sensitively. The name of the contact |
| name_not_contains | String | Checks if name does not contain a specified string, case-sensitively. The name of the contact |
| name_not_ends_with | String | Checks if name does not end with a specified string, case-sensitively. The name of the contact |
| name_not_in | String | Checks if name is not equal to one of the specified values. The name of the contact |
| name_not_like | String | Checks if name does not match a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
The name of the contact |
| name_not_starts_with | String | Checks if name does not start with a specified string, case-sensitively. Never uses an index. Consider using not_like (with the % placeholder) for a case-insensitive filter that can use an index. The name of the contact |
| name_starts_with | String | Checks if name starts with a specified string, case-sensitively. Never uses an index. Consider using like (with the % placeholder) for a case-insensitive filter that can use an index. The name of the contact |
| phone | String | Checks if phone equals a specified string, case-sensitively. If an index exists on phone, it can be used. See also like for a case-insensitive filter. The phone number of the contact |
| phone_contains | String | Checks if phone contains a specified string, case-sensitively. The phone number of the contact |
| phone_ends_with | String | Checks if phone ends with a specified string, case-sensitively. The phone number of the contact |
| phone_gt | String | Checks if phone is greater than a specified value. The phone number of the contact |
| phone_gte | String | Checks if phone is greater or equal a specified value. The phone number of the contact |
| phone_in | String | Checks if phone is equal to one of the specified values. The phone number of the contact |
| phone_like | String | Matches phone against a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
If an index exists on phone, it can be used for the literal prefix (the part until the first placeholder). The phone number of the contact |
| phone_lt | String | Checks if phone is less than a specified value. The phone number of the contact |
| phone_lte | String | Checks if phone is less or equal a specified value. The phone number of the contact |
| phone_not | String | Checks if phone does not equal a specified string, case-sensitively. The phone number of the contact |
| phone_not_contains | String | Checks if phone does not contain a specified string, case-sensitively. The phone number of the contact |
| phone_not_ends_with | String | Checks if phone does not end with a specified string, case-sensitively. The phone number of the contact |
| phone_not_in | String | Checks if phone is not equal to one of the specified values. The phone number of the contact |
| phone_not_like | String | Checks if phone does not match a pattern case-insensitively with the following placeholders: % matches any sequence of characters, including the empty string;
_ matches exactly one character;
\ can be used to escape the placeholders (use \\ for a literal backslash);
The phone number of the contact |
| phone_not_starts_with | String | Checks if phone does not start with a specified string, case-sensitively. Never uses an index. Consider using not_like (with the % placeholder) for a case-insensitive filter that can use an index. The phone number of the contact |
| phone_starts_with | String | Checks if phone starts with a specified string, case-sensitively. Never uses an index. Consider using like (with the % placeholder) for a case-insensitive filter that can use an index. The phone number of the contact |
