When creating a view in InfoMaker or Internal Setup Utility, you run the CREATE VIEW SQL command. We recommend that you create a new view based on an existing view shipped with Smart Instrumentation and modify the column selection in the new view as you require. When creating a new view, make sure the following requirements are met:
-
The view must contain the CMPNT_ID column.
-
The CMPNT_ID value must be unique.
-
The number of rows in the created view must match the number of rows in the COMPONENT table of Smart Instrumentation. The COMPONENT table contains the appropriate instrument tags that must appear in the view.
-
When creating a view for a specific project in an owner operator domain, you must create the same view in the Domain schema, As-Built schema, Project schema of the target project, target Combined Project schema.
For details on establishing a connection to a database schema available in Smart Instrumentation, see Connecting to the Smart Instrumentation Database in the Internal Setup help.