...
Here, we notice something a bit different, the Comparator is much longer than the first example above, this is the standard format in which you can specify different comparators, in this example, we are using the comparator "like" (please refer to #Comparators Comparators for more details on what this condition does).
...
To use any of the following comparators (please see #The The Condition Structure for more details of where Comparators fit into the whole scheme of things.
Comparator Name | Alias | Availability | Description |
|---|---|---|---|
Equals | "=", "=eq:" | All | Expression is true if the value in the specified field equals the specified value in the expression. Comparisons using the equals operator are case-insensitive. |
Not Equals | "=ne:", "=not equals:" | All | Expression is true if the value in the specified field does not equal the specified value in the expression. Comparisons using the equals operator are case-insensitive. |
Like | "=lk:", "=like:" | All | Expression is true if the value in the specified field matches the characters of the text string in the specified value. The LIKE operator is similar to the SAME operator in SQL; it provides a mechanism for matching partial text strings and includes support for wildcards.
|
Greater Than | "=gt:", "=greater than:", "=after:" | Numeric/Date | Expression is true if the value in the specified field is greater than the specified value. For dates, the format MUST be "yyyy-MM-ddTHH:mm:ssZ" |
Greater Than Or Equal To | "=gte:", "=greater than or equal to:" | Numeric/Date | Expression is true if the value in the specified field is greater than or equal to the specified value. |
Less Than | "=lt:", "=less than:", "=before:" | Numeric/Date | Expression is true if the value in the specified field is less than the specified value. For dates, the format MUST be "yyyy-MM-ddTHH:mm:ssZ" |
Less Than Or Equal To | "=lt:", "=less than or equal to:" | Numeric/Date | Expression is true if the value in the specified field is less than, or equals the specified value. |
In | "=in:" | All | If the value equals any one of the specified values. For example: |
Not In | "=not in:" | All | If the value does not equal any of the specified values. For example: |
Includes | "=includes:" | Multi-Select Fields | Includes (contains) the specified string. You can use ";" to specify AND for two or more strings. Use ; for multi-select picklists when two or more items must be selected. For example: AAA;BBB. You can have multiple includes by specifying a comma-separated list of values |
Excludes | "=excludes:" | Multi-Select Fields | Excludes (does not contain) the specified string. You can use ";" to specify AND for two or more strings. Use ; for multi-select picklists when two or more items must be selected. For example: AAA;BBB. You can have multiple excludes by specifying a comma-separated list of values |
Between | "=between:" | Numeric/Date | Expression is true if the value in the specified field is greater than or equal to the specified lower limit AND the value in the specified field is less than or equal to the upper limit. Example: Amount=between:5000,10000 will restrict the results to only those that have an Amount between 5000 and 10000. For dates, the format MUST be "yyyy-MM-ddTHH:mm:ssZ" |
Note About Includes/Excludes
A match will result on any field value that contains 'AAA' and 'BBB' or any field that contains 'CCC'. For example, the following will be matched:
...