Object Types Reference > Siebel Object Types >

Join Constraint


Siebel Object Types > Business Component > Join > Join Constraint

A join constraint is a constant-valued search specification applied to a column during a join. It is for use with outer joins.

Properties
Property
Description/Usage
Valid Values/Examples

Destination Column (O)

Column of the destination table to apply the constraint to.

Example: LANG_CD.

Name (R)

Name of the join constraint.

 

Value (O)

A non-null constant value or constant function, such as LoginId(), PostionId(), and DivisionId().

GetProfileAttr can be used, but be aware that profile attributes can be persistent or dynamic. If dynamic, this property must contain a value before the join fires. If the property does not contain a value, then GetProfileAttr returns a null and the join fails.

Example: Language().

See Also

Join

Object Types Reference