Siebel Advisor Administration Guide > Advanced Modeling for Advisor > Trigger and Target Feature Tables for Advisor Applications >

Example of Creating Trigger and Target Tables

In this example, you add Trigger and Target Feature tables that populate a drop-down list with appropriate year values, based on whether a user wants to purchase a new or used car.

At runtime, if users of the Advisor application select New for Class of Car, they have one option in the Car Year drop-down list.

If users select Used, they can choose from a list of year values.

Creating the YEAR Target Table

Creating the YEAR target table requires three steps:

• Creating a target table named YEAR.
• Creating row types for the table.
• Populating the target table with values.

Each of these steps is explained in the following procedures.

To create the YEAR target table

1. Navigate to Administration - Product > Advisor Pagesets > My Pagesets.
2. Select a pageset, and click the Feature Tables tab.
3. Choose New Record from the list menu.

   A new Feature Table record appears.

4. Enter YEAR in the Name field.
5. From the Table Type drop-down list, select Target.

To create the row types for the YEAR Target table

1. Navigate to Administration - Product > Advisor Pagesets > My Pagesets.
2. Select a pageset, and click the Feature Tables view tab.
3. In the Feature Tables tab, select the YEAR Target table.
4. On the Editor tab, click New.

   A new row appears in the editor.

5. Click the Row Type picklist icon to open the Feature Table Rowset picklist.
6. Click New.

   The Feature Table Rowset dialog appears.

7. In the Name text box, enter YEAR_NEW.
8. Click Save.
9. Repeat Step 4 through Step 6 and create a second new rowset named YEAR_USED.

To populate the YEAR target table

1. Navigate to Administration - Product > Advisor Pagesets > My Pagesets.
2. Select a pageset, and click the Feature Tables view tab.
3. Select the YEAR target table from the Feature Tables list.
4. On the Editor tab, create a row with values for the YEAR_NEW rowset.
5. In the Feature table editor, create a row with values for the YEAR_USED rowset.

Creating the CLASS Trigger Table

Use the following procedure to create the CLASS Trigger Table.

To create the CLASS Trigger Table

1. Navigate to Administration - Product > Advisor Pagesets > My Pagesets.
2. Select a pageset, and click the Feature Tables view tab.
3. From the Feature Table applet menu, choose New.

   A new Feature Table window appears.

4. In the Name text box, enter CLASS.

   From the Type drop-down list, select Trigger.

5. From the Designer tab form menu, choose New Record.
6. In the Column Name text box, enter YEAR.

   In the Designer tab, the Target Table button is enabled.

7. Click the Target Table button to open the Target Table picklist.
8. Select the YEAR target table and click OK.
9. Follow the steps in To enter data in an Advisor pageset feature table.

   NOTE:  In the column tied to the Target table, you can only enter row types.

Creating UI Controls to Display the Trigger and Target Values

Use the following procedure to create UI controls to display the Trigger and Target values.

To tie the Trigger and Target Feature tables to UI controls

1. Navigate to Administration - Product > Advisor Pagesets > My Pagesets.
2. Select a pageset.
3. In the Input UI tab, click New.
4. Enter values in the new row.

   For more information, see To create input UI controls with Advisor.

5. Click New again.
6. Enter values for the second row.