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 Lists 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.

16.7.4.3 Subscribing to a List of Values

Subscribe to a list of values on the Lists of Values, Edit page.

Subscriptions enable developers to reuse shared components across several applications in a workspace. To learn more about shared component subscriptions, see Using Shared Component Subscriptions.

Tip:

You can also subscribe to a list of values by copying it and then subscribing. See Copying or Subscribing to a List of Values.

To subscribe to a list of values:

  1. Navigate to the Lists of Values page:
    1. Navigate to the Workspace home page.
    2. Click the App Builder icon.
    3. Select an application.
    4. On the Application home page, click Shared Components.
    5. Under Other Components, click Lists of Values.

      The Lists of Values page appears. Note that the report includes the following columns: Subscribed From, Subscription Status, and Subscribers.

  2. Select a list of values.
    The Lists of Values, Edit page appears.
  3. To subscribe to a list of values:
    1. Find the Subscription region.
    2. Subscription, Subscribe From - Select a master list of values to subscribe to and click Apply Changes.
    3. Confirm your selection and click Subscribe.

      The subscribed component is automatically refreshed from the selected master.

  4. To refresh a list of values:
    1. Find the Subscription region.
    2. Subscription, Refresh List - If the list of values is already subscribed, click Refresh List.
    3. Click Apply Changes.
  5. To unsubscribe from a list of values:
    1. Find the Subscription region.
    2. Subscription, Unsubscribe - Click Unsubscribe.