Defining queries

Define queries using existing Infor HMS 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 HMS data model and have a good working knowledge of SQL.

To define queries:

Select Administration > Start Center Setup > Queries.
On the List View tab, click New Record. The Record View tab is displayed.
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.
To open the Object Browser, click Launch Object Browser.

Normal

Select if you want this query to appear in the Normal 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.
Click Save.