Supported operators for Salesforce Get/Push Queries

Last updated Jan 29 2018
Get/ Push Operators
Learn about the supported operators for your Salesforce integration

Following are the operators:

1- Equals - Use for an exact match
2- Not equal - Shows results that don’t have the value you enter. 
3- Contains - Use for fields that include your search string, but sometimes also include other information. 
4- Not Contains - Eliminates records that don’t contain the value you enter.
5- Includes - Available when you choose a multi-select picklist as the selected field. Use this operator to find records that include one or more of the values you enter.
6- Excludes - Available when you choose a multi-select picklist as the selected field. Use this operator to find records that do not contain any values that match the ones entered.
7- IN - If the value equals any one of the specified values in a WHERE clause.
8- Not IN - If the value does not equal any of the specified values in a WHERE clause.
9- Greater than -  Use for results that exceed the value you enter.
10- Less Than -  Use for results that are less than the value you enter.
11- Is empty -  Shows fields that were left un-filled.
12- Is not empty -  Shows fields that have any type of input in them.
 
CommentsLogin Required
Didn’t find what you were looking for?
Try the following for assistance or Use the Search box.