Query Builder and the Engineering Data Editor - Intergraph Smart Instrumentation - Training - Intergraph Process, Power & Marine Documentation

Intergraph Smart Instrumentation Tutorial

PPMProductFamily
Engineering and Schematics
PPMProduct
Intergraph Smart Instrumentation
PPMCategory
Training
Version_SPI_custom
2018 (12.0)

The Query Builder allows you to create queries using a graphic user interface (GUI) with no knowledge of SQL whatsoever. You can use these queries to create and display data in different types of views and reports in the Engineering Data Editor (EDE) and to create custom Find queries.

Using an intuitive graphic user interface you can create definitions of reports and customized views that can be saved and displayed in the Engineering Data Editor (EDE) without any prior knowledge of the database structure or SQL statements. The Query Builder’s graphic user interface uses the engineering data from the software based on Item Types, their Attributes, and Relationships. After selecting the required item types, attributes, and relationships the Query Builder saves this information in the Reference Explorer until you open the query using the EDE where it displays the results.

In this section you will perform the following tasks:

  1. Create a basic query, save the query to the Reference Explorer, and preview the query.

  2. Generate an EDE View from a Query, save the EDE View to the EDE Explorer.

  3. Manipulate the data in the EDE View.