Configuring Siebel Business Applications > Configuring Business Components, Links, and Business Objects > Configuring a Business Component Field >
Creating a Joined Business Component Field
You can add a join to a business component, and then reference the join in a field. To create a joined business component field
- In Siebel Tools, in the Object Explorer, click Business Component.
- In the Business Components list, locate the business component where you must add a join.
- In the Object Explorer, expand the Business Component tree, and then click Join.
- In the Joins list, add a new record, using values from the following table.
|
|
Table |
Name of the joined table. For example, enter S_ADDR_ORG to access address data. |
Alias |
Name of the join. For example: Contact - S_ADDR_ORG
It is recommended that you define the alias so that it is different from the table. |
Outer Join Flag |
If you must get all the records in the business component even if the joined fields are empty, then set Outer Join Flag to TRUE. |
Comments |
Optional. |
- In the Object Explorer, expand the Join tree, and then click Join Specification.
- In the Join Specifications list, add a new record, using values from the following table.
|
|
Name |
Name of the join specification. For example, Primary Address Id. |
Destination Column |
Primary key column in the joined table. For example, ROW_ID. If you create a join on a column other than ROW_ID, then you must enter a value in the Destination Column property. An empty value in the Destination Column property indicates that the destination column is ROW_ID, which is typically the primary key. For a join to a party table, the destination column must reference the PAR_ROW_ID column in the joined table. |
Source Field |
Foreign key field in the business component. For example, Primary Address Id. If empty, then the Source Field references the Id field, which indicates a one-to-one relationship between the business component and the joined table. |
- Optional. Add a Join Constraint:
- In the Object Explorer, expand the Join Specification tree, and then click Join Constraint.
- In the Join Constraints list, add a new record, using values from the following table.
|
|
Name |
Name of the join constraint. For example, Primary Address Id. |
Destination Column |
Column in the joined table where you must apply a search specification. For example, OU_ID. |
Value |
The search specification. For example: GetProfileAttr("Primary Address Id")
For more information, see Options to Filter Data That Siebel CRM Displays in an Applet. |
- In the Object Explorer, click the Field object type in the Business Component tree.
- In the Fields list, add a new record, using values from the following table.
|
|
Name |
Name of the joined field. |
Join |
Join alias for the table where this field gets data. For example, Primary Account Address. |
Column |
Column in the joined table where this join gets data. For example, ADDR_NAME. |
Text Length |
Same length as the column where this join gets data. |
Type |
Data type that is compatible with the column where this join gets data. For example, DTYPE_TEXT for a Varchar column. |
- Compile and test your modifications.
For more information, see Using Siebel Tools.
|