Property Path Constraints

In a property, the path traverses through relations to reach the correct field for this property.
The syntax for defining a property path is:
relation:relation:field

For example, the Current Owner Phone path for a case looks like:
case_owner2user:user2employee:phone

When traversing through OTM or MTM relations, the result would be multiple sets of data.
In order for the property to resolve to a single piece of data, a constraint can be used.
The syntax for using a constraint is:
relation(column_name operator value):field

For example:
contact2contact_role(role_name='President'):contact_role2site:site_name

The valid operators for constraints are:

The following operators are NOT supported in constraints:

See Also

Limitations - SQL Constraints in Property Paths

Property Expansion in Rule Conditions

Next

RuleManager Features

Property Path Constraints