Using a List of Values

...

Distribution

IS User

Related Procedures

None

Ownership

The Training Manager is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

IS Form
N ® Projects
Find Projects

Choosing a Value from a List

To choose a value within a field with three dots as shown here , select the dots and the List of Values window appears.

Search for a value as follows;

clicking in the Find field
enter your search criteria in the Find field
select [Find]

You can use the percent “%” wildcard character to represent any character or group of characters. For example, use “120%” to represent any number beginning 120, and so on. You can also use the underline “_” character to represent any single character. For example, “120_4” can represent 12004, or 12014.
Select a value directly from the list by entering % in the Find field and selecting [Find]. Scroll through the list and then double-click the value to choose it, or click once on the value and then click OK to choose it.

Once you choose a value, the list window closes and inserts the value into the current field. To close a list window without choosing a value, select Cancel.

AutoSelection

Using the list of values feature called AutoSelection you can select a valid name from the list with a single keystroke. When you display the list window, you can type the first character of the name you want in the Find field. If only one choice begins with the character you enter, AutoSelection selects the choice, closes the list window, and enters the value in the appropriate field.

List Search

You can use the AutoReduction feature to reduce a list when you know the first few characters of your name selection. If you do not know the initial characters of your choice, but do know that your choice contains a certain word or set of characters, you can perform a list search to reduce a list.

In the list window, enter any group of characters as search criterion in the Find field and click the Find button. You can use wildcard characters such as the percent sign (%) which represents any number of characters, or an underline (_), which represents a single character in your search criterion.

For example, to reduce a list to only those choices that contain the phrase “schedule,” you would type %schedule% in the Find field and click Find. In any of these list search queries, it does not matter whether you use uppercase or lowercase letters as the search is not case sensitive.

Long-List Fields

If a field has a “long-list”—that is, a list of more than 100 values—IS Applications will display the Enter Reduction Criteria for Long List window when you try to display the LOV.

Because it takes less time to display a reduced list than a complete long-list, IS Applications prompts you to enter the first few characters that occur in your value of interest to reduce the complete list. However, to view the entire long-list, enter the percent sign (%) at the prompt and all of the values will be displayed.

Note: To avoid excessive network traffic and reduced performance, try to enter specific criteria, other than just a percent sign (%), whenever possible.

Power List

The Power List feature provides an even faster method of data entry. If a field displays an ellipse indicating a list is available and you know the value you want, simply enter the first few characters of the value in the field and press [Tab]. Power List will complete the entry for you. You can also include wildcard characters with your entry. You do not need to display the list window. If more than one value matches the characters you specify, a list window containing those values is displayed. If no values match the characters you enter, a list window containing all the values appears.

Effective: 08/13/04

Revision: 3

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.