Field Type | Supported Comparators | Example |
text/ textarea | equal, not_equal, contains, not_contains , starts_with, ends_with | { "comparator": "equal", "field": { "api_name": "text" }, "value": "zoho" } |
email | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "contains", "field": { "api_name": "Email" }, "value": "patricia" } |
phone | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "equal", "field": { "api_name": "Phone" }, "value": "9999999999" } |
website | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "contains", "field": { "api_name": "website" }, "value": "zoho" } |
picklist | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "equal", "field": { "api_name": "picklist" }, "value": [ "Cold Call", "Call" ] } |
multiselectpicklist | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "equal", "field": { "api_name": "Multi_Select_Picklist" }, "value": [ "Cold Call", "Call" ] } |
date | equal, not_equal, less_than, greater_than, between, not_between, less_equal, greater_equal | Example 1: { "comparator": "less_than", "field": { "api_name": "date" }, "value": "01-01-2025" } Example 2: { "comparator": "between", "field": { "api_name": "date" }, "value": [ "01-01-2025", "02-01-2025", } |
datetime | equal, not_equal, less_than, greater_than, between, not_between, less_equal, greater_equal | { "comparator": "equal", "field": { "api_name": "date" }, "value": "2025-01-01T12:12:06+05:30" } |
autonumber | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "starts_with", "field": { "api_name": "Auto_Number" }, "value": "A01" } |
integer | equal, not_equal, less_than, less_equal, greater_than, greater_equal, between, not_between | { "comparator": "equal", "field": { "api_name": "integer" }, "value": 4 } |
currency | equal, not_equal, contains, not_contains, starts_with, ends_with | { "comparator": "equal", "field": { "api_name": "Currency" }, "value": "INR" } |
double | equal, not_equal, less_than, less_equal, greater_than, greater_equal, between, not_between | { "comparator": "equal", "field": { "api_name": "Double" }, "value": "123" } |
Boolean | equal | { "comparator": "equal", "field": { "api_name": "Boolean" }, "value": true } |
big int | equal, not_equal, less_than, less_equal, greater_than, greater_equal, between, not_between | { "comparator": "equal", "field": { "api_name": "id" }, "value": "1234800023843923" } |
lookup | equal, not_equal, less_than, less_equal, greater_than, greater_equal, between, not_between | { "comparator": "equal", "field": { "api_name": "Lookup.name" }, "value": "Name1" } |
ownerlookup/userlookup | in, not_in | { "comparator": "equal", "field": { "api_name": "Modified_By", "id": "400029000000000479" }, "value": [ { "id": "400029000003984001", "name": "User1" }, { "id": 400029000003984002, "name": "User2" } ] } |
formula | Comparator will depend on the return type | - |
Field Type | Supported Operators |
Date, DateTime | equals, not_equal, greater_equal, greater_than, less_equal, less_than, between, in |
Integer, Currency, Decimal | equals, not_equal, greater_equal, greater_than, less_equal, less_than, between, in |
Boolean | equals, not_equal |
textarea | equals, not_equal, starts_with |
Lookup (user/owner) | equals, not_equal, in |
Picklist, Autonumber | equals, not_equal, in |
Text, Email, Phone, Website | equals, not_equal, starts_with, in |
multiselectpicklist | equals, not_equal, in, starts_with. |
bigint | equals, not_equal, greater_than, greater_equal, less_than, less_equal, between, in |
percent | equals, not_equal, greater_than, greater_equal, less_than, less_equal, between, in |
formula | The supported operators of the formula datatype will depend on the return type of the formula |