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. |