Creating joins and fields

A Single Value Field can be mapped either to a column in the business component's base table, specified by the Table property of the business component, or to a column in a joined table. In addition, we can use the Siebel Query Language syntax to create calculated fields.

In this section, we will use a scenario from the case study introduced in Chapter 3, Case Study Introduction to demonstrate how to create single value fields.

Case study example: Displaying data from joined tables

As stated in the requirements list in Chapter 3, the customer wishes to display the full name of the person who committed the last update on a record as a link that opens an e-mail form. The following procedure describes how to implement this requirement for the Service Request business component.

Case study example: Creating a join

In order to implement the preceding requirement, we must start with creating a new Join object definition in the Service Request business component. The Join and...