Map selected fields - SmartPlant Foundation - IM Update 48 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)
  1. In the Tables pane, select a table. The column names of the selected table appear 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 page, select a business object from the Select Mapping Class list.

    SHARED Tip Click Manage Optional Interfaces Manage optional interfaces to instantiate optional interfaces for the selected business object.

    • The business objects defined in the property lists module are displayed in the Select Mapping Class list.

    • A pattern can be mapped only to one business object at any point in time.

  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.

    SHARED Tip Click Download Transposed Properties to view the transposed properties in the Selected Fields pane.

    • If the interface ISPFTEPublishedObjectCollection realizes the business object, then the relationship SPFTEFComprisedOf is created.

    • If the interface IFDWData realizes the business object, then the relationship FDWComprisedOf is created.

  6. Select an option from the Map Type list. You can select from the following options:

    • Property - Select a property list from the Property List list and a property from the Properties list.

    • RelDef - Select a relationship from the relationship definition list.

    • FileDef - Select a File Attribute like FileName or FilePath. If you select the FilePath option, you need to provide the folder name (or UNC path) of the remote file.

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

  7. Click Save.