Introduction
Operators are a part of Selectors that allow you to get very specific about what you want the Selector to return (for example, Find accounts where the annual revenue for the account is greater than $1,500,000). Operators will differ depending on the type of field used in the Selector.
Date Operators | Description |
---|---|
Equals | Exact match on selected date |
Does Not Equal | Any date other than the selected date |
Before | Any date before the selected date |
After | Any date after the selected date |
Between | Any date between the selected date range |
In the Past | A date within the selected timeframe |
In the Past Before | Any date before the selected timeframe |
In the Future | Any date within the selected timeframe |
In the Future After | Any date after the selected timeframe |
Exists | Date field is not empty |
Does Not Exist | Date is NULL |
Integer Operators | Description |
---|---|
Equals | Exact match on number entered |
Does Not Equal | Any number except the exact match on the number entered |
Greater Than (>) | Numbers larger than the number entered |
Greater Than or Equal To (>=) | Exact match on the number entered and any larger number |
Less Than (<) | Numbers smaller than the number entered |
Less Than or Equal To (<=) | Exact match on the number entered and any smaller number |
Between | Numbers within the selected range |
Exists | Number field is not empty |
Does Not Exist | Number is NULL |