A static list validation can be a drop-down list or an auto-complete component. You can create static list validations that provide a static list of options to the user. For example, XYZ Corporation creates a validation called Engineering Teams for its engineering teams. The validation consists of the values New Product Introduction, Product One, and Product Two.
Be careful when creating validations (drop-down lists and auto-complete fields) that are validated by lists. Each time the set of values changes, you must update the validation. We recommend validating using an SQL query or PL/SQL function to obtain the values from a database table.
For example, XYZ Corporation needs a field validation that lists all users on their support team. They have a static validation that is validated by a list of users, but any time members join or leave the support team, the list must be manually updated.
To create a static list validation:
Open a new or existing validation, see Configure validations.
In the Component Type field, select Drop Down List, Check Box, or Auto Complete List.
Note: The Check Box option is available only when the Enable Checkbox List Validation feature toggle is turned on. For details, see Use feature toggles to turn on/off features.
The fields in the Validation window change dynamically, depending on your selection.
In the Validated By field, select List.
For Selection mode, select one of the following:
The Add Validation Window opens.
Provide the information for the validation value as described in the following table.
Underlying code for the validation value. The code is the value stored in the database or passed to any internal functions, and is rarely displayed. For example, 123.
Displayed meaning for the validation value in the drop-down list or auto-complete. For example, western region.
More complete description of the value specified in the Meaning field.
Select to ensure that the value is displayed in the list of values.
Default value for the list. This value is initially displayed in drop-down lists (it is not used for auto-completes). There can be only one default value per list.
To add more values and keep the Add Validation Value window open, click Add.
To save your changes and close the window, click OK.
To change the sequence of the validation values in the Validation Values section,
- To change the order in which validation values are listed, use the up and down arrow buttons.
To sort the validation values alphabetically according to the Code column, click the button.
Note: This alphabetical sorting is case-insensitive.
All validation codes are sorted by letter, so "value3" is listed after "value12". To avoid this, we recommend that you prefix numbers with some zeros. For example, use "value003" and "value012" instead.
To specify the sequence of a specific validation value, select the desired value, and then click the button. In the input box that pops up, enter the sequence number of the row that you want to move the selected value to.
For example, if you enter
1for the selected value and click OK, the selected value is moved from its original place to the first.
The sequence of the validation values determines the order that the values are displayed in the list.
To copy existing values defined in other validations, click Copy From and query an existing list-validated validation and choose any of the validation values. Click Add or OK in the Copy From window and the selected value or values are added to the list.
To delete list validations, select the row you want to delete and click Delete.
Type characters and then type the Tab key. The selection window opens and lists entries that begin with the specified characters.
Type characters, and then type the Tab key. The selection window opens and lists entries that contain the specified character string. This is the same behavior as a wild card search, which uses the% character at the beginning of the search text.