Working with Search Criteria
In addition to using QBE and wildcards to search for records, you can define additional search criteria by creating a query. The Query control appears on Find Browse, Search/Select, and Power Browse forms that have a Find button, unless the form appears in a popup window (such as when using the visual assist). Additionally, the Query control appears in the Data Browser, which enables you to view the data in tables and business views and save the search criteria as a query.
See Viewing the Data in Tables and Business Views in this guide.
The queries created using the Query control are Enhanced Queries, which differ from the Saved Queries that users might have created in previous releases. You can convert the format of the old Saved Queries to Enhanced Queries by using a conversion process.
The query feature enables you to select additional fields from a form and add conditions to narrow the search results. Queries enable you to create searches that are more specific than the search results from wildcards and QBE columns alone. The system combines the conditions defined in the form filter fields, the QBE line, and the query to retrieve records from the database.
Security options are available to prevent users from performing searches if they have not entered search criteria in the form filters or QBE columns. If application query security has been implemented, you receive an error or warning message that informs you that your search has been suppressed.
If you want to search for records without using a query, set the Query field to All Records.
For more information on the Query Control and creating and managing queries, see "Queries" chapter in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide