Creating Lists of Values
A list of values (LOV) is a static or dynamic set of values used to display a specific type of page item, such as popup lists of values, a select list, a check box, a radio group, or multiple select lists.
Creating a LOV as a shared component has a number of advantages:
-
It can be added to any page within an application.
-
All LOV definitions are stored in one location, making them easy to locate and update.
Topics in this section include:
Creating a Named LOV at the Application Level
You define named (or shared) LOVs at the application level by running the Create LOV Wizard and adding them to the List of Values repository. All LOVs can be defined as static or dynamic. Static lists are based on predefined pairs of display values and return values. Dynamic lists are based on a SQL query you write that selects values from a table.
To create a named LOV:
-
On the Workspace home page, click the Application Builder icon.
-
Select an application.
The Application home page appears.
-
Click the Shared Components icon.
-
Under User Interface, select Lists of Values.
The Lists of Values page appears.
-
To create a LOV, click Create.
-
Follow the on-screen instructions.
New named LOVs are added to the List of Values repository. Note to add the LOV to a page you must edit the appropriate item or column and select the named LOV.
About the List of Values Page
Once you create an LOV, it appears on the List of Values page.
Description of the illustration lov_page.gif
Use the Navigation bar at the top of the page to search for a LOV by name or change the page display. For example, you can change the default display by making a selection from View list. Available options include:
-
Icons (the default) displays each LOV as a large icon. To edit an LOV, click the appropriate icon.
-
Details displays each LOV as a line in a report. To edit an LOV, click the name.
About Static LOVs
Static LOVs are based on a static list of display values and return values you specify when you run the Create LOV Wizard. To create a static LOV, run the Create LOV Wizard and select the LOV type Static. Oracle Application Express stores the display values, return values, and sort sequence you specify in the List of Values repository. Once you add a static LOV to the repository, you can create an item and display it as a check box, radio group, select list, or popup list based on this definition.
Editing an Existing LOV
To edit an existing LOV, select the LOV on the Lists of Values page.
To edit an LOV:
-
On the Workspace home page, click the Application Builder icon.
-
Select an application.
-
Click Shared Components.
-
Under User Interface, select Lists of Values.
-
Select an LOV.
The Edit List of Values page appears.
-
To learn more about a specific item on a page, click the item label.
When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".
-
Click Apply Changes.
About Navigation Alternatives
The Edit List of Values page is divided into the following sections: Name, Subscription, Source, and Comments.
You can access these sections by scrolling down the page, or by clicking a navigation button at the top of the page. When you select a button at the top of the page, the selected section appears and all other sections are temporarily hidden. To view all sections of the page, click Show All.
See Also:
"About the Edit All Icon"Bulk Edit of Static LOVs
You can edit the display values of all static LOVs by clicking the Grid Edit button on the Edit List of Values page.
To perform a bulk edit of static LOVs:
-
On the Workspace home page, click the Application Builder icon.
-
Select an application.
-
Click Shared Components.
-
Under User Interface, select Lists of Values.
By default, LOVs display as icons.
-
Change the default display. Select Details from the View list and click Go.
-
Locate the Static LOV and select the LOV name.
-
Click the Grid Edit button located under Subscription.
-
Edit the appropriate display values and click Apply Changes.
Referencing Session State Within an LOV
You can reference session state by using bind variables. Keep in mind that referencing session state makes an LOV a bit less reusable, but is still a recommended development practice. In the following example, this LOV only works if the item called my_deptno contains a valid department number.
SELECT ename, empno FROM emp WHERE deptno = :P1_DEPTNO
Referencing a Null Value in an Item Based on an LOV
LOVs have a null display value option and a null return value option. The null display value is the value the end user sees in the list indicating the no selection from the proper (non-null) values of the list will be made. When a user selects a null display value, the LOV's null return value is sent to the application when the page is submitted. If the developer has left the null return value unspecified (or empty), the actual value transmitted is not an empty string or an Oracle null, but the literal %null%. The application must be prepared to deal with this literal and treat is as the null selection.
Be aware of this behavior when writing code to evaluate submitted values. For example, suppose a page evaluates the submitted item P1_X and you need to use the PL/SQL expression replace(:P1_X,'%'||'null%',null) to prepare the item for permanent storage in session state or for passing to DML or other APIs.
To avoid problems, be aware of the appropriate way to code %null% in expressions that occur in page computations, processes, and validations. You must break up the string so that the application does not replace %null% with a null value in the page metadata when it is saved. Consider the following example:
'%'||'null%'
Accessing LOV Reports
Application Builder includes a number of reports designed to help you better manage LOVs.
To access LOV reports:
-
On the Workspace home page, click the Application Builder icon.
-
Select an application.
-
When Application Builder appears, click Shared Components.
-
Under User Interface, select Lists of Values.
-
Select one of the following tabs at the top of the page:
-
Search
-
Subscription
-
Utilization
-
History
-
-
Follow the on-screen instructions.
Search
Click Search to display the Search Dynamic Lists of Values page. Use this page to search the queries that make up dynamic LOVs. Enter a query in the Query Contains field and click Go.
Subscription
Click Subscription to display the List of Values Subscription page. This page displays all subscribed LOVs in your application.