Draw a Join Between Tables
Each table has a connector area in the bottom right corner. Create a join between two tables by clicking and dragging a line between the two connector areas. The Create Join window opens, displaying the available joins between the two tables.
On the Create Join window, click the Show Joins in Use checkbox to filter the list to only those joins that are actively in use. Enter text in the Filter list field to further filter the list. If the join should be an outer join, select from the Outer Join Against drop-down list which table the outer join should be against. This means that rows or instances from the selected table should be included even when the join conditions between the two tables are not satisfied. Essentially, selecting a value for Outer Join Against means “allow null entries for the unselected table when joining against the selected table”. If a join is an outer join, the link arrow is green instead of blue.
Some joins are link joins, which are an explicitly modeled association between two types. Each of the types plays either the A or B role in the association as specified in the data model. Some link joins can go in either direction, that is, either type can be the A or B role. When these joins are selected in the Create Join or Modify Join windows, the Role A and Role B designation displays at the bottom of the window:
Click the arrow between the roles to swap which type is Role A and Role B:
Select the desired join, and click OK.
Once a join has been added, you can select Modify Join from the right-click actions menu for the join. The join can be modified by choosing a different join, or changing the Outer Join Against selection for the join.
| The display of Show Joins in Use checkbox on Add Table and Join pop-up window is based on com.ptc.windchill.enterprise.queryBuilder.showjoinsinuse property setting. If the value of the property is not defined or set to true, then Show Joins in Use checkbox is displayed on Add Table and Join pop-up Window. If the value of the property is set to false, then checkbox is not displayed. For large set data report, it is recommended to set the value of the property to false. This property needs to be updated in wt.properties file. |