A query is a tool that you can use to construct a question or request directed at the database, and then view the results. The records that are returned by the query can include fields from one query source, such as a family or another query, or several related query sources. After you construct a query, it can be saved in the Catalog for future use.
You can think of a query as a set of criteria that helps you define the specific information that you want to retrieve from the database. For example, consider a query on the Pump family where Asset ID, Asset Manufacturer, and Asset Installation Date are the fields selected for inclusion in the output. Instead of using this query to return all the Pump records in the database, you might want to return only the Pump records where the Asset ID, Manufacturer, and Asset Installation Date match certain criteria. For example:
So, using this example, your overall query criteria is that you want to see the pump ID, manufacturer, and installation date for all pumps that were installed after a particular date and manufactured by a particular manufacturer.
After you learn how to create basic queries, you can expand that knowledge to create more complex queries. The more you learn about creating queries to retrieve detailed information from the database, the better you can incorporate these queries into other areas of GE Digital APM. For example, you can create queries on which to base graphs and you can configure queries to generate detailed reports.
Copyright © 2018 General Electric Company. All rights reserved.