Data types

The IBM® OpenPages® with Watson™ application provides various data types from which you can choose.

After you select a data type for a field and save it, only the parameters or settings for the data type can be modified; you cannot change the data type itself.

To display more parameters for a selected data type, click the double arrow icon next to the data type selector.

Boolean data type

A logical operator that has the following predefined values: true (default) or false.

To change the default value, click the Default Value arrow and select another value from the list.

Classifier data type

The classifier data type accepts simple string text that can be interpreted and classified by a Natural Language Classifier that uses Watson technology. It has the following settings:

Classifier Configuration Name
The name of a classifier configuration defined in Administration > Cognitive Services > Natural Language Classifiers.
Classifier Input Field
The field that provides text that is interpreted and classified by a Natural Language Classifier. Format is <Field Group>.<Field Name>.

For more information, see Defining a Classifier Configuration.

Currency data type

  • Include Conversion - this setting controls whether the exchange rate and base amount conversion are visible.

    If this value is set to:

    • True - the following items are displayed in the currency field (this is the default setting):

      Local Currency Code (drop down)

      Local Amount (text input)

      Exchange Rate (text input)

      Base Code (static text)

      Base Amount (static text)

      For example, you might use this setting when the field represents a currency amount relative to a specific point in time where the exchange rate is applicable, such as a financial loss on a specific date.

    • False - the following items are displayed in the currency field:

      Local Currency Code (drop down)

      Local Amount (text input)

      For example, you might use this setting when the field represents a hypothetical currency amount not relative to a specific point in time, such as Inherent Severity on the Risk object.

  • The currency data type accepts numeric values with decimal places for the following settings:
    Setting
    Description
    Minimum Value
    The lowest allowable currency value that is accepted for this field.
    Maximum Value
    The greatest allowable currency value that is accepted for this field.

    If a user enters a value that is either below or above the specified value range, an error message is shown.

Note:
  • The Minimum Value and Maximum Value settings are expressed in terms of the base currency (base currency is set during installation).
  • You cannot use non-numeric characters when you enter currency values. For example, either 125000 or 125,000 is legal, but not $125000. This format is set per user locale.

    For more information about working with currency, see Adding a currency field to a field group.

Date data type

The date data type default value is blank and this value cannot be changed. (The date picker pop-up box defaults to the current date.)

Decimal data type

The decimal data type accepts numeric values with decimal places for the following settings:

Minimum Value
The lowest allowable decimal value that is accepted for this field.
Maximum Value
The greatest allowable decimal value that is accepted for this field.
Default Value
The default value of the field is blank.

To display a default decimal value in the field, type a numeric value that is between the minimum and maximum allowable values.

If a user enters a value that is either below or above the specified value range, an error message is shown.

Enumerated String data type

The enumerated string data type accepts a list of string values and has these settings:
Multi-valued
Sets whether a user is allowed to select more than one value from the list.

If the box is:

Cleared
only one value can be selected from the list. This is the default setting.
Selected
multiple values can be selected from the list.

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:

You cannot convert a multi-value selection setting to a single value selection.

Add Value
A string value that you want in a list of values.

To add a value to the list:

  1. In the Add Value box, type a string value.
  2. Click Add.
  3. To add another value to the list, repeat Steps 1 and 2.

    To remove a value from the list, select the value then click Delete only if the field is not in use.

After it is defined, you cannot change a field from a multi-value enumerated string data type to single-value enumerated data type.

Default Values
The field, by default, is empty and has no value.

To display a default value from the list, click the arrow and select a value from the list.

To reorder the list of values, see Changing the order of enumerated string values.

To set the display of the enumerated string data, such as a list, radio buttons, or check boxes, you must do it through the profile, see Configuring a display type for enumerated strings.

Integer data type

The integer data type accepts numeric values without decimals for the settings:
Setting
Description
Default Value

The field, by default, is empty and has no value.

To display a default integer value in the field, type a numeric value that is between the minimum and maximum allowable values.

Minimum Value
The lowest allowable integer value that is accepted for this field.
Maximum Value
The greatest allowable integer value that is accepted for this field.

If a user enters a value that is either below or above the specified value range or a non-integer value, an error message is shown.

Long String data type

A long string is considered to be any text of length more than 4000 bytes. Long strings allow users to enter more than 4000 bytes in a single field.

You can encrypt long string field values up to a maximum of 2 MB in the IBM OpenPages with Watson repository.

The long string has two sub types, medium and large.

The size of the medium sub type is fixed to 32 KB. The medium sub type is the only sub type that is supported for FastMap uploads.

The size of the large sub type set by default to 256 KB. It can be increased by changing the Platform > Repository > Resource > Large Text > Maximum Size setting.
Tip: In the user interface, the OpenPages folder is hidden in the Administration Settings folder hierarchy. To author an XML settings path, include the OpenPages folder after the Settings folder in the path.
Enter a value in bytes. The maximum size applies to all large subtype long strings.
Important: After it is set, this value cannot be reduced.
Note: The maximum size is a hidden setting. To show hidden settings set Applications > Common > Configuration > Show Hidden Settings to true.
See Long string fields

Reporting Fragment data type

The Reporting Fragment data type displays a component (such as a bar or line chart) from a Cognos® report or dashboard in a field. For details, see Reporting fragment fields.

Simple String data type

The simple string data type, by default, displays data as text. The default value of the field is blank. The maximum size of a simple string is 4000 bytes.

You can encrypt simple string field values in the IBM OpenPages with Watson repository.

To display a default value in the field, type a string of either plain text or HTML-formatted text.

After it is defined, you cannot change a field defined as simple string data type to long string data type.

To set the display of the string data to another type, such as a user drop-down, user or group selector, rich text area , you must do it through the profile. For details, see Configuring display types for simple string fields.

Single File data type

For legacy internal use. Do not use because this data type cannot be used in profiles.