Sample Predicate Expressions for Datasets

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.

Did this article solve your issue?

Let us know so we can improve!

Product Area