Operators in Selectors

  • Updated

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

 

Was this article helpful?

2 out of 2 found this helpful