16.7.4 Editing an Existing List of Values

Edit an existing list of values from Shared Components.

16.7.4.1 Editing a List of Values in Shared Components

Edit a list of values by navigating to Shared Components, Other Components and selecting List of Values.

To edit a list of values from the Shared Components page:

  1. Navigate to the Shared Components page:
    1. On the Workspace home page, click App Builder.
    2. Select an application.
    3. On the Application home page, click Shared Components.
      The Shared Components page appears.

    Tip:

    You can also access Shared Components from Page Designer by clicking Shared Components (Shared Components) on the Page Designer toolbar.
  2. Under Other Components, select List of Values.
    The Lists of Values page appears.
  3. Select a list of values.

    The Edit page appears. The appearance of the Edit page changes depending upon the type of list as shown in the following examples:

    • Static List of Values - For Static lists, the Edit page resembles the following example. In this example, STATUS contains four Display and Return values: Pending, Open, On-Hold, and Closed.

      Description of edit_static_lov.png follows
      Description of the illustration edit_static_lov.png

      Click the Edit icon edit a value or the sequence. Click Add Row to add more Display/Return value combinations.

    • Dynamic List of Values - For Dynamic lists, the Edit field resembles the following example. In this example, the list is based on the EBA_DEMO_PROJECTS table in a local database.

      Description of edit_dynamic_lov.png follows
      Description of the illustration edit_dynamic_lov.png

      Edit the attributes to reconfigure the Source or Column Mappings.

      Use Additional Display Columns to define additional display columns for item types that support multiple display columns, such as Popup LOV. If adding additional display columns, ensure that the return column is included in the column list. If you do not want it displayed to users, set the return column to Visible No and Searchable No .

    Tip:

    To learn more about an attribute, see field-level Help.
  4. Click Apply Changes to save your changes.

16.7.4.2 Editing List of Values in Bulk

Edit the display values of all static list of values by clicking the Grid Edit tab on the List of Values page.

To perform a bulk edit of static LOVs:

  1. Navigate to the Shared Components page:
    1. On the Workspace home page, click App Builder.
    2. Select an application.
    3. On the Application home page, click Shared Components.

      The Shared Components page appears.

  2. Under Other Components, select List of Values.
  3. Click the Grid Edit tab.
  4. Edit the Display Text and click Apply Changes.