Review the samples to see how to structure a predicate expression.
The samples are based on the following Opportunity dataset.
| Opportunity | Expected_Rev | Owner | OwnerRoleID | Stage_Name | IsDeleted |
|---|---|---|---|---|---|
| OppA | 2000.00 | Bill | 20 | Prospecting | True |
| OppB | 3000.00 | Joe | 22 | Closed Won | False |
| OppC | 1000.00 | 可爱的花 | 36 | Closed Won | False |
| OppD | 5000.00 | O’Fallon | 18 | Prospecting | True |
| OppE | Joe | 22 | Closed Won | True |
Let’s take a look at some examples to understand how to construct a predicate expression.
| Predicate Expression | Details |
|---|---|
'OwnerRoleID' ==
"$User.UserRoleId" |
Checks column values in the User object. |
'Expected_Rev' > 1000 &&
'Expected_Rev' <= 3000 |
|
'Owner' = "Joe" || 'Owner' =
"Bill" |
|
('Expected_Rev' > 4000 || 'Stage
Name' == "Closed Won") && 'isDeleted' != "False" |
Parentheses specify the order of operations. |
'Stage Name' == "Closed Won"
&& 'Expected_Rev' > 70000 |
|
'Owner' == "可爱的花" |
String contains Unicode characters. |
'Owner' ==
"O\’Fallon" |
Single quote in a string requires the escape character. |
'Stage Name' == "" |
Checks for an empty string. |