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. Open the Queries form.
  2. Click New Record.
  3. Query—Enter the code for which to define a query.
  4. 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.
  5. Normal—Select if you want this query to appear in the Normal lookups.
  6. Data Collection—Select if you want this query to appear in the data collection lookups.
  7. Lookup—Select if you want this query to appear in all lookups.
  8. KPI—Select if you want this query to appear in the KPI lookups.
  9. Inbox—Select if you want this query to appear in the Inbox lookups.
  10. Chart—Select if you want this query to appear in the Chart lookups.
  11. Click Save Record.