Create joins (optional)

1. Click the Joins tab.

2. To create a join, drag your originating column in the primary table to the target column in the secondary table. The join is displayed as a gray line connecting the two columns together. (You may have to scroll to the right to see the selected tables)

3. You can specify the type of join. Right-click the join and select Specify Join Type. In the Specify Join window, click Inner Join or Left outer join.

4. You can remove a join. Right-click the join and select Remove Join.

   If the base table is joined with the primary key of another table, the relation is one-to-one and the selected columns are single valued. In other cases, columns are multi-valued. For multi-valued cases, when more than one column in the association table is selected, it is a compound multi-value. The wizard generates a bean for these columns and the multi-value will be an array of this bean. The name of this bean is based upon the display name of the secondary table.

   Personalization only supports joins from one column in the primary table to one column in the secondary table. The column you are joining from within the primary table must be included in the resource collection. If your resource collection is content managed, you can only include one column from the secondary table.

 

Back