Understanding Queries - PAS ICS Integrity - 7.3 - Help - Intergraph

ICS Integrity User Guide

Language
English
Product
PAS ICS Integrity
Subproduct
ICS
Search by Category
Help
PAS Version
7.3

Integrity provides the query builder to help you query the Integrity database for the information you need. You can use a built-in query, or you can build and save custom queries to search references, change logs, and more. You can also build queries using SQL statements and compound queries based on the results of other queries.

When you save a query, you can make it private or public. Private queries are accessible only by the creator. Public queries are accessible by anyone. You can also choose to save a query with the asset model, which makes the query available for all assets of that type.

For example, you may initially create several private queries for the specific assets you manage. You can customize those queries to meet your specific needs. Over time, other users may want to use your queries for the assets they manage. You can save the private query as public and check Save with Asset Model so other users can use it with their assets of the same type.

After you have the saved queries you need, you can run them when needed, or you can base reports on the saved queries and schedule them to run hourly, weekly, monthly, or when new data is imported and processed.