Map selected fields to relationship definition - SmartPlant Foundation - IM Update 48 - Help - Hexagon

You can map the column names of the database to the relationship definition.

1. In the Tables pane, select a table or view. The column names of the selected table or view are displayed in the Table Properties pane.

2. In the Table Properties pane, select one or more check boxes beside the column names to include them in the query.

3. Click Map Selected Fields to map the selected fields to the existing database properties. By default, Name, Description, and Class ID are mapped.

4. In the Map Selected Fields pane, select a business object from the mapping class list. The business objects defined in the property lists module are displayed in the mapping class list.

5. In the Selected Fields pane, select a column to enable the Mapping Field pane. The Selected Fields pane displays all the selected fields and the custom properties.

6. Set Property as the Rel Def.

7. Select a relationship definition from the Rel Def list. The Rel Def list displays all the relationship definitions realized by the selected object.

   

   • You can select the Consolidate check box to transfer the domain object property to the Data Capture object.

   • The Map Fields View displays the UML diagram of the mapped relationship.

8. Click Save.