Siebel 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.

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


Siebel Object Types Reference Copyright © 2006, Oracle. All rights reserved.