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

  1. In Siebel Tools, in the Object Explorer, click Business Component.
  2. In the Business Components list, locate the business component on which you must add a join.
  3. In the Object Explorer, expand the Business Component tree, and then click Join.
  4. In the Joins list, add a new record, using values from the following table.
    Property
    Value

    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.

  5. In the Object Explorer, expand the Join tree, and then click Join Specification.
  6. In the Join Specifications list, add a new record, using values from the following table.
    Property
    Value

    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.

  7. (Optional) Add a Join Constraint:
    1. In the Object Explorer, expand the Join Specification tree, and then click Join Constraint.
    2. In the Join Constraints list, add a new record, using values from the following table.
      Property
      Value

      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.

  8. In the Object Explorer, click the Field object type in the Business Component tree.
  9. In the Fields list, add a new record, using values from the following table.
    Property
    Value

    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.

  10. Compile and test your changes.

    For more information, see Using Siebel Tools.

Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.