Join Constraint

A join constraint is a constant value search specification that Siebel CRM applies to a column during a join. Outer joins use it.

This object type occurs in the following location in the object hierarchy:

Siebel Objects > Business Component > Join > Join Constraint

The following table describes properties that Siebel CRM uses with a join constraint.

Property Description

Property	Description
Destination Column (O)	Specifies the column of a destination table. Siebel CRM to applies the constraint to this destination table. For example, you can use the following value: `LANG_CD`
Name (R)	Specifies the name of the join constraint.
Value (O)	Specifies a constant value or constant function that is not empty, such as LoginId, PositionId, or DivisionId. For example, you can specify the following value: `Language()` You can specify GetProfileAttr. A profile attribute can be persistent or dynamic. If it is dynamic, then this Value property must contain a value before Siebel CRM uses the join. If this property does not contain a value, then GetProfileAttr returns a null value and the join fails.

Destination Column (O)

Specifies the column of a destination table. Siebel CRM to applies the constraint to this destination table. For example, you can use the following value:

LANG_CD

Name (R)

Specifies the name of the join constraint.

Value (O)

Specifies a constant value or constant function that is not empty, such as LoginId, PositionId, or DivisionId. For example, you can specify the following value:

Language()

You can specify GetProfileAttr. A profile attribute can be persistent or dynamic. If it is dynamic, then this Value property must contain a value before Siebel CRM uses the join. If this property does not contain a value, then GetProfileAttr returns a null value and the join fails.