Managing Queries

You use Query Manager to create, modify, and save queries. Click the icon to the right of the Query field to enter Query Manager. You can also use the Ctrl+E hot key combination to toggle between normal mode and Query Manager mode. Depending on the value in the Query field when you enter Query Manager, the options for a new query or an existing query appear in the Query Manager side panel. You can change the width of the Query Manager side panel, which causes a corresponding adjustment in the JD Edwards EnterpriseOne form until the minimal width is reached.

The icons in the Query Manager side panel are available for all User Defined Objects (UDOs) and are discussed in the "UDO Life Cycle and Statuses" of the JD Edwards EnterpriseOne Tools Foundation Guide.

• Save: See Creating and Saving Queries to Search for Data

• Save As: Copying Queries

• Request to Publish: See Publishing UDOs

• Reserve: See Modifying UDOs

• Delete: See Deleting Personal UDOs

When you enter Query Manager, a plus sign on the form designates each field and QBE column that you can select for a query. When you click a field or QBE column, the item appears in the Query Manager side panel with the appropriate comparison selections for the item's data type. Any items that you select display an X in the Query Manager side panel, which indicates that they have been selected. You can remove an item from the Query Manager side panel by clicking it.

When you edit the criteria in a query, both the query item and its corresponding field or QBE column on the form are highlighted.

The Populate Query icon enables you to enter values in fields and QBE columns on the form, and then click the Populate Query button to automatically create the query for you. The system populates the comparison selections for each item according to its data type.

The following table describes the fields in the Query Manager side panel:

Query Manager Options

Field	Description
Name	Select either (add new query) or an existing query from the drop-down list. The default value for the Query field is (add new query), unless an existing query was selected before entering the Query Manager. The (add new query) selection enables you to create a new query. Select an existing query to run it or modify it.
Set As Default	Select this option to designate a query as the default. Only one query can be the default query for a form. The default query is used whenever the form opens, until the user selects another query or the All Records selection.
Run When Selected	By selecting this option, you do not have to click the Find button to run the query. The query will run automatically whenever you select it. If you select this option for a default query, the query will run automatically when the form opens, unless it opens in a pop-up window (such as when using the visual assist) or when values are passed into the form by a form interconnection. Note: When creating a query used by Watchlists, ensure that the "Run When Selected" option is selected. When creating a query to be used by a an analytical component on a Composed Page, it is recommended that this option be turned off for better performance.
Clear Form When Selected	Select this option to clear any header field values that are specified in the application version and automatically populated when the application version is launched.
Match All	Select this option if you want the query results to include all of the criteria specified in the query.
Match Any	Select this option if you want the query results to include any (not all) of the criteria specified in the query.
Fields and QBE Columns	Form fields and QBE columns that display a plus sign can be included in a query. Click the plus sign of the field or QBE column to include it in a query.
Comparison List	When you select a field or QBE column to include in a query, fields display to the right of the item in the Query Manager side panel that enable you to customize the search criteria for the item. The comparison types that display for each data item (such as equal, not equal, starts with, between, is blank, etc.) depend on the data type.
Set Special Value	Some conditions enable you to set a value for comparison. For example, if you select a date field and the "between" comparison type, the Set Special Value option enables you to specify the dates to be compared.

Comparison Types

The following table describes the comparison types that are supported for each data type when it is included in the search criteria.

Data /Type	Example	Comparison Types
String	Order Type (DCTO)	Equal, not equal, starts with, ends with, contains, between, in list, is blank, is not blank
Character	Type Code (TYC)	=, !=, <, <=, >, >=, between, in list
Numeric	Address Number (AN8)	=, !=, <, <=, >, >=, between, in list
Date	Order Date (TRDJ)	=, !=, <, <=, >, >=, between, in list
JDEUtime	Start UTime (TASUTIME)	=, !=, <, <=, >, >=, between, in list

The "in list" comparison type enables you to create a list of values for a data item. When you select "in list" from the comparison drop-down list, the Add More Value icon appears. Click the icon to display another field in which to enter the next value. To remove a value from the list, delete the value in the value field. The field is removed unless it is the only value field in the list.

Special Values

Fields or QBE columns that are based on string or date data types enable you to specify additional search criteria by using the Set Special Value option. Click the down arrow to the right of the value field to display the Set Special Value pop-up window. The Set Special Value window provides additional search options for the field or QBE column. For example, you could specify search criteria for orders that are due 5 days from the current date.

To set special values, make the appropriate selections in the Set Special Value window and then click OK. To clear special values, click the Reset button. The following table describes the special value options that are available for each data type.

Data /Type	Special Value Options	Description
String	Login User ID	Some forms enable you to customize a query to return records with data related only to the user ID of the person who is logged in.
Date	Today + or Today - Value Days, Months, or Years	Use special values to search for dates that are a specified number of days, months or years before or after the current date. In the Set Special Value pop-up window, select + or -, enter a number, and then select days, months, or years from the drop-down list.