Define queries using existing HxGN EAM data or SQL statements. Use SQL statements to define complex validation queries or validation queries to multiple system tables.
Define this type of validation only if you are familiar with the HxGN EAM data model
and have a good working knowledge of SQL.
-
Select Administration > Start Center Setup > Queries.
-
Click New Record.
-
Specify this information:
Query - Specify the code for which to define a query.
SQL Statement - Specify the SQL statement.
To verify the SQL Statement, click Test SQL. A message indicating the accuracy of the statement is displayed.
Normal - Select if you want this query to appear in the Normal lookups.
Data Collection - Select if you want this query to appear in the data collection lookups for asset tracking.
Lookup - Select if you want this query to appear in all lookups.
KPI - Select if you want this query to appear in the KPI lookups.
Inbox - Select if you want this query to appear in the Inbox lookups.
Chart - Select if you want this query to appear in the Chart lookups.
Equipment Ranking - Select if you want this query to appear in the Equipment Ranking lookups.
-
Click Save Record.