Configuring Siebel Business Applications > Configuring Business Components, Links, and Business Objects > Customizing 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 on which 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 retrieve 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 to which 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 Displayed 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 from which this field retrieves data. For example, Primary Account Address. |
Column |
Column in the joined table from which this join retrieves data. For example, ADDR_NAME. |
Text Length |
Same length as the column from which this join retrieves data. |
Type |
Data type that is compatible with the column from which this join retrieves data. For example, DTYPE_TEXT for a Varchar column. |
- Compile and test your changes.
For more information, see Using Siebel Tools.
|