Defining enumerated string fields
Define an enumerated string field by setting the data type, adding values, and defining whether it is encrypted and single or multi-valued. A default value can also be specified.
Before you begin
Procedure
Results
After an enumerated field, either single or multi-valued, is created, a true/false toggle named Hierarchical might be displayed. It is an internal setting and cannot be changed.
After it is defined, you cannot change an enumerated string field from a multi-value enumerated string data type to single-value enumerated data type. You cannot delete an enumerated string field.
If you are using Oracle, you can convert a single value selection setting to a multi-value selection setting.
If you are using IBM® Db2® and you want to convert a single value selection setting to a multi-value selection setting, you must:
- Perform the conversion when there is limited or no activity on the system if the reporting schema is enabled. The conversion can cause significant system delays in OpenPages due to locking conflicts on the Db2 platform. For more information, see System delay when modifying object types and fields (Db2).
- Complete remediation steps after the conversion is finished. For more information, see Remediating after an Enumerated String field is changed to a multi-select field (Db2). Or, drop the reporting schema, change the setting, and then re-create the reporting schema.