Selecting Criteria for Application Queries

After you select the fields to query, you want to limit the search to the range of data you want to display. The Criteria-Keys and Criteria-Filter tab contains parameters you can use to further define the query. The choices depend on which information source you selected.

You can limit an application query by using key field settings and field filter values. You can also select a maximum number of records to return on the worksheet.

Note: If you don't know the values for the selected key fields, you can look them up on the Infor Lawson form where they appear.
Maximum # of records to return Specify in the maximum number of records to display on the worksheet.
Set Key Field Values

Key fields on the forms you selected automatically appear in the Field column. If you set a key field value, the results of your query begin with the record matching the value. For top level key fields, which appear at the top of the key field list, the data returned stops at a break.

For example, if you set the value of the _f3:COMPANY field to 500 and request 9000 records, the data returned on the worksheet starts with company 500. Records associated with companies with numbers below 500 are ignored.

If there are fewer than 9000 records for Company 500, the data returned on the worksheet ends with the last record for Company 500 and does not continue with records for Company 600.

Set Field Filter Values

Fields you select automatically appear in the Field column.

To limit the query results, specify a value into the Filter Value field.

To add multiple field filter values, separate values with a comma but do not add a space after the comma. For example, to limit your query to data from fiscal years 2001 and 2002, specify 2001,2002 in the Filter Value field for _f8:FISCAL-YEAR.