Associate User-Defined Views - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

This option enables you to associate a Smart Instrumentation database view that you created in an external application such as InfoMaker. After associating an appropriate database view, you can use the data it contains in specifications. When creating a user-defined database view, you can include in this view any combination of Smart Instrumentation table columns, with each column belonging to a different Smart Instrumentation table. Using database views, you can retrieve data from the required tables and display this data in specification documents. For example, a certain instrument is assembled on a line. You use your database view to automatically retrieve data related to that line, for example, line process data, pipe related material, and so forth.

Before using this procedure, make backups of all your user-defined views. When upgrading your Smart Instrumentation version, note that in the new version, some tables or columns might have been modified. If you have upgraded your database after associating user-defined views, you cannot use the views in which the table records do not match the new table records of the new database. To enable the use of these views, you must run a set of SQL statements to re-create the user-defined views.

  1. On the Specifications Module window menu bar, select Actions > Specification Views.

  2. On the Specification Views dialog, select New.

  3. In the new row, type the appropriate view name.

    SHARED Tip The name of the new view must be exactly the same as the name defined in your external application (the name is not case- sensitive). The software validates the name and checks whether the view complies with the Smart Instrumentation-specific conditions.

  4. Under Item Type, from the list, select the item type you want to associate with the current view.

    SHARED Tip For a user-defined view, you can select an item type from a list. For the default views, the item type is fixed. The displayed item type indicates that you can only use the current view in a specific item specification. For example, you can only use the default view cable_type in a cable specification.

  5. Select OK.

    The associated view becomes available for selection on the Regenerate Page dialog in the Page Editor.