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.
| 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 |