Creating Queries

Queries enable you to select fields and QBE (Query By Example) columns and then add conditions to narrow your search results. In this way, the data is more specific than the search results from filter fields and QBE columns alone. For example, instead of entering >120111 in the Invoice Date QBE column for dates after December 1, 2011, a query enables you to specify a date range, such as between December 1, 2011, and December 31, 2011. The query feature enables you to refine the data selection so that the report displays only those records that meet your needs. The system combines the conditions defined in the filter fields, the QBE line, and the query itself to retrieve desired records.

You can save queries that you use frequently so that you can easily retrieve them and modify the data that you want to appear in a report.

For more information about queries, see "Queries" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide.