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 ...

Get Oracle Siebel CRM 8 Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.