Notes and Limitations for Lists of Values

Review the notes and limitations listed here when planning to use lists of values (LOV):

• Only one identity field is supported in a list of values.
• LOVs support strings, Boolean values, and integers. Decimal numbers, dates, and date-time values are not supported.
• Excel drop-down lists using data validation may not be compatible with the add-in.
• For ADF REST services, if the OpenAPI service metadata includes complete information for a list of values, the add-in reads the metadata and configures the LOV automatically. The field must use one of the supported x-hints.controlType values: combo_lov, choice, or input_text_lov. The metadata must also include an x-links entry with an x-lov definition for the field. The x-lov.definedOn value must point to the field, and the definition must identify the LOV data source, identity field, display fields, and any required finder or filter parameters.
• If the ADF REST service metadata does not include the complete x-lov definition for a field, configure the list of values manually. See Configure a List of Values with a Business Object.
• For any read-only field (column or form), the add-in still swaps identity values for display values. However, the search-and-select window does not appear when the cell is selected.
• When using an expression that refers to a field in an ancestor layout, ensure:
  • The referenced field is present in the ancestor layout.
  • The ancestor columns in the current layout are configured properly even when you don’t expect to create rows. See Add Ancestor Columns to Dependent Layouts.
• A field’s LOV can be dependent on an ancestor field as long as that ancestor field does not have an LOV that is dependent on another field.
• Dependent LOVs are not supported on ancestor columns.

• When creating a cascading set of LOVs, you can use a “local” LOV (one based on a local data source) as the initial list, but not as one of the subsequent lists. A “remote” LOV (one based on a business object as the data source), however, can depend on a value in a local LOV.

  In a cascading list of values, the value selected in one list determines the range of values that users can select from subsequent lists.

• Keep the following in mind if using the Select Single Value Automatically for Create check box:
  • This feature is available for business object fields and row variable fields, including fields that use local lists of values. It is not available for custom action fields or row finder variables.
  • This feature is not supported in windows like the Search Editor.
  • If automatic selection fails, click the cell to review the issue.