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