Understanding the Query Control

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 the JD Edwards EnterpriseOne Tools Foundation Guide guide.

Note: 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. See "Converting Saved Queries to Enhanced Queries" in the JD Edwards EnterpriseOne Tools Runtime Administration Guide.

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.

See "Managing Application Query Security" in the JD Edwards EnterpriseOne Tools Security Administration Guide.

You can design and save queries for search criteria that you use often to find records. Queries can be designated to run automatically by selecting the "Run query when selected" option, which enables the query to search without having to click the Find button.

Additionally, you can designate a saved query as the default query for a form. A default query with the "Run query when selected" option will run whenever you enter the form, as well as any time you select the query from the drop-down query list. If a default query has not been defined, the Query field displays "All Records" when the form appears.

Note: A default query will not run automatically if values are passed into the form by a form interconnection, or if the "Run query when selected" option is not selected.

If you want to search for records without using a query, set the Query field to All Records.

Any queries that you save are listed alphabetically under the My Queries label in the query drop-down list. The My Queries subgroup also includes an All Records selection, which enables you to search without queries. Any queries that you save are available to you only; no other user can access them unless they are copied and designated as public queries. If public queries are available, they are listed alphabetically under the Public Query subgroup in the query drop-down list.

See "Making Private Queries Public" in the JD Edwards EnterpriseOne Tools Runtime Administration Guide.