3.8.2.2 Additional Shared LOV Features

If you anticipate reusing a list of values multiple times, define a shared List of Values (LOV). This named component supports additional features and data sources when compared with a locally-defined one.

For example, when you create a shared LOV with static entries, you can optionally configure a condition with each entry to indicate when it should appear in the list.

A shared LOV whose choices are not static is known as a Dynamic List. Its entries come from a SELECT statement or a remote data source. The query or data source can provide additional columns beyond the usual display value and return value. One of these additional columns can be the name of icon to display in each row, and you can use these extra columns in the custom list entry display formatting of Select One, Select Many or Combobox page items. With a Popup LOV, you can also display the additional columns, let users search on them, and return their values into other page items.