Building a List of Values

Related topics

Oracle Portal provides two methods for creating a List of Values (LOV):

  • A static LOV contains values that you hard code when you create it.

  • A dynamic LOV is dynamically generated from a SQL query of a table column. It contains all values in the column.

    Note: If you use a bind variable in your query, the dynamic LOV can only be used in form components. When the end user runs the form, the values from the form must provide the values for the bind variable.

To build an LOV, you must have Edit or higher access privileges on the application that will own the finished LOV.

To build a static LOV:

  1. On the Oracle Portal Home page, click on the shortcut bar.

  2. Click the Applications tab in the Oracle Portal Navigator.

    The Name column of the Navigator displays the names of all applications in which you have privileges to build components.

  3. Click the name of the application in which you want to build the LOV.

  4. Click Create, then List of Values. The Lists of Values page displays.

  5. Click Static List of Values.

  6. In the Owner list, chose the application that will own the finished List of Values.

    Note: The list displays only applications in which you have Edit or higher access privileges.

  7. In the Name field, enter a name for the LOV. Choose a name that describes the LOV's function; for example, DEPTNO_LOV.

  8. In the Default Format list, choose a default display format for the LOV, for example a check box or radio group. Developers can change this format when building the component's customization form.

  9. In the Show Null Value list, choose whether to display null values in the LOV.

  10. In the Display Value column, type each value you want to include in the LOV. End users of the LOV will be able to select from this list.

  11. For each Display Value you specify, type a Return Value. This value is passed as an argument to the component. The Return Value can be the same as the Display Value.

  12. In the Display Order column, enter numbers beginning with 1 to set the order that values appear in the LOV. For example, enter 1 for the first display value you want to appear at the top of the list, 2 for the second value, and so forth.

    Hint: You can skip numbers. For example, entering 2, 4, 8, 6 in the Display Order column produces the same LOV order as 1, 2, 4, 3. If you don't choose a Display Order, Display Values appear in the LOV in the order they are entered in this wizard step.

  13. Click OK to create the List of Values.

  14. (Optional) To test the LOV, click Run.

 

To build a dynamic LOV:

  1. Follow steps 1-6 above.

  2. Click Dynamic List of Values.

  3. In the Owner list, choose the application that will own the finished List of Values.

    Note: The list displays only applications in which you have Edit or higher access privileges.

  4. In the Name field, enter a name for the LOV. Choose a name that describes the LOV's function; for example, DEPT_LOV.

  5. In the Default Format list, choose a default display format for the LOV, for example a check box or radio group.

  6. In the Show Null Value list, choose whether to display null values in the LOV.

  7. In the Enter SQL Query field, enter a SQL select statement that displays a value, then a database value (this is what is passed to the stored procedure); for example:

    select ename, empno from scott.emp

    Note: If you use a bind variable in your query, the dynamic LOV can only be used in form components. When the end user runs the form, the values from the form must provide the values for the bind variable.

  8. Click OK.

  9. (Optional) To test the LOV, click Run.

 

Related topics

Building an LOV based on another LOV

 

Back to top