Defining queries

Define queries using existing Infor EAM data or SQL statements. Use SQL statements to define complex validation queries or validation queries to multiple system tables.

Note:  Define this type of validation only if you are familiar with the Infor EAM data model and have a good working knowledge of SQL.

To define queries:

  1. Select Administration > Start Center Setup > Queries.
  2. Click New Record.
  3. Specify this information:
    Query
    Specify the code for which to define a query.
    SQL Statement
    Specify the SQL statement.
    Note: 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.
  4. Click Save Record.