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
    Enter the code for which to define a query.
    SQL Statement
    Enter the SQL statement.
    Note: To verify the SQL Statement, click Test SQL. The system displays a message indicating the accuracy of the statement.
    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.
    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.
  4. Click Save Record.