Create a Find Query - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

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

Many actions in Smart Instrumentation require you to first select items before continuing the action, for example; Loops, Tags, Instruments and so forth. Before selecting the required items, you have to find them. The software comes shipped with queries that are used by the Find dialog boxes to find and display the correct content. You can use these queries "As Is" or create your own find query. Creating your own find is very similar to creating a regular query, except that there are certain properties that are mandatory. For information on how to create a query, see Create a Query. Without these properties your query cannot be displayed by the software. These properties vary depending on the module and Find dialog the query is created for. When the query is selected from the Query list in a dialog, a set of filters within the software and these mandatory properties display the required values in the Find grid.

The following lists the Smart Instrumentation modules and the properties that must be included in your query.

Module

Reports/Find dialog

Mandatory Properties

Calibration

All reports (For Loop reports replace Tag class with Loop.)

Item Type

  • Instrument

Properties

  • Instrument Name

  • Tag Class

Instrument Index

  • Loop Number properties

  • Move Loop Number

  • Rename Multiple Loop Numbers

  • Delete Loop Number

  • Duplicate Loop Number

Item Type

  • Loop

Properties

  • Loop Name

Associate Loop

Item Type

  • Loop

Properties

  • Loop Number

  • Tag Number properties

  • Move Tag Number

  • Delete Tag Number

  • Duplicate Tag Number

Item Type

  • Instrument

Properties

  • Instrument Name

  • Tag Class

Maintenance

Schedule Preventive Maintenance Event

Item Type

  • Instrument

Properties

  • Instrument Name

  • Tag Class

Create Work Request

Item Type

  • Instrument

Properties

  • Instrument Name

  • Tag Class

Create Repair Form

Item Type

  • Instrument

Properties

  • Instrument Name

  • Tag Class

Specifications

Open Specification > Instrument
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Types

  • Instrument

  • Specification

Properties

  • Tag Class

  • Instrument Name

  • Case Name (Specification)

Open Specification > Cable
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Cable

Properties

  • Plant/Reference Cable

  • Cable Name

Open Specification > Panel
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Panel

Properties

  • Plant/Reference Panel

  • Panel Name

Open Specification > Loop
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Loop

Properties

  • Loop Number

Open Specification > Wiring Equipment
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Wiring Equipment

Properties

  • Plant Reference Wiring Equipment

  • Wiring Equipment Name

Open Specification > Hook-Up Item
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Hook-Up Item

Properties

  • Item Number

Specifications by Item Type > Instrument
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Instrument

  • Specification

Properties

  • Tag Class

  • Instrument Name

  • Case Name (Specification)

  • Form Number (Specification)

Specifications by Item Type > Cable
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Cable

  • Specification

Properties

  • Plant/Reference Cable

  • Cable Name

  • Form Number (Specification)

Specifications by Item Type > Panel
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Panel

  • Specification

Properties

  • Plant/Reference Panel

  • Panel Name

  • Form Number (Specification)

Specifications by Item Type > Loop
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Loop

  • Specification

Properties

  • Loop Number

  • Form Number (Specification)

Specifications by Item Type > Hook-Up Item
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Hook-Up Item

  • Specifications

Properties

  • Item Number

  • Form Number (Specification)

Specifications by Item Type > Wiring Equipment
(The item type corresponds to the item type selected in the Open Specification dialog.)

Item Type

  • Wiring Equipment

  • Specification

Properties

  • Plant Reference Wiring Equipment

  • Wiring Equipment Name

  • Form Number (Specification)

Save as File (Print to PDF)
(Instrument Type only)

When generating and saving PDFs in a Windows environment, you must have read/write permission for the folder where you save the PDF files. This is because of security features in Windows which only allows users with access to a folder, to save to that folder, even if the path and folder were set in Smart Instrumentation.

SHARED Tip If you are unable to save a PDF, try changing the path and folder to a folder that you are sure you have access to.

Item Type

  • Instrument

  • Specification

Properties

  • Tag Class

  • Instrument Name

  • Form Number (Specification)

  • Case Name (Specification)

Save as Excel
(Instrument Type only)

The Save-as Excel functionality only works with the 32-bit version of Microsoft Excel. You must also have installed from the Microsoft Download center the following file: Microsoft Access 2013 Runtime.exe.

Item Type

  • Instrument

  • Specification

Properties

  • Tag Class

  • Instrument Name

  • Form Number (Specification)

  • Case Name (Specification)

Print Specs into PDF File > Instrument

Item Type

  • Instrument

  • Specification

Properties

  • Tag Class

  • Instrument Name

  • Case Name (Specification)

  • Form Number (Specification)

Print Specs into PDF File > Loop

Item Type

  • Loop

  • Specification

Properties

  • Loop Number

  • Form Number (Specification)

Print Specs into PDF File > Cable

Item Type

  • Cable

  • Specification

Properties

  • Cable Name

  • Plant/Reference Cable

  • Form Number (Specification)

Print Specs into PDF File > Panel

Item Type

  • Panel

  • Specification

Properties

  • Panel Name

  • Plant/Reference Panel

  • Form Number (Specification)

Print Specs into PDF File > Wiring Equipment

Item Type

  • Wiring Equipment

  • Specification

Properties

  • Wiring Equipment Name

  • Plant/Reference Wiring Equipment

  • Form Number (Specification)

Print Specs into PDF File > Hook-Up Item

Item Type

  • Hook-Up Item

  • Specification

Properties

  • Item Number

  • Form Number (Specification)

Delete Specifications

The same as the Specifications per Item Type

Wiring

Cable Layout and Cable Schedule

Item Type

  • Cable

Properties

  • Cable Name

  • Plant/Reference Cable

Cable Harness

Item Type

  • Cable

    Properties

  • Plant/Reference Cable

  • Cable Name

  • Cable Harness

Panel Strip

Item Type

  • Terminal Strip

Properties

  • Plant/Reference Terminal Strip

  • Terminal Strip Name

  • Terminal Strip Category

Panel Strip Signals

Item Type

  • Terminal Strip

Properties

  • Plant/Reference Terminal Strip

  • Terminal Strip Name

Panel Signals

Item Type

  • Panel

Properties

  • Plant/Reference Panel

  • Panel Name

Wiring Equipment Connections

Item Type

  • Terminal Strip

Properties

  • Terminal Strip Name

  • Plant/Reference Terminal Strip

Plug and Socket

Item Type

  • Terminal Strip

Properties

  • Plant/Reference Terminal Strip

  • Terminal Strip Name

  • Terminal Strip Category

Multi-Strip

Item Type

  • Terminal Strip

Properties

  • Plant/Reference Terminal Strip

  • Terminal Strip Name

  • Terminal Strip Category

I/O Tag Assignment

Item Type

  • Wiring Equipment

Properties

  • Plant/Reference Wiring Equipment

  • Wiring Equipment Name

  • Wiring Equipment Category Type

Amplifier Actual Load

Item Type

  • Wiring Equipment

  • Panel

Properties

  • Wiring Equipment Name

  • Wiring Equipment Category

  • Panel/Reference Wiring Equipment

  • Panel Sub-Category (Panel)

Single Speaker

Item Type

  • Instrument

Properties

  • Tag Class

  • Instrument Name

  • You cannot use the same Item Type more than once in your query. You can use more than one different Item Type in your query.

  • A search using just the wildcard (*) to represent one or more characters, is not supported. It must be combined with an alphanumeric character.