Bookshelf Home | Contents | Index | PDF     

Siebel Object Types Reference > Siebel Object Types Reference > Business Component Object Types >

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:

Table 67 describes properties that Siebel CRM uses with a join constraint.

Table 67. Properties of the Join Constraint
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.
      
Siebel Object Types Reference Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.