Specifying logical types

You must specify the logical type of a property type to inform your deployment about the type of data it is processing so it can enable and disable operators. By specifying the logical type, you can enter or import data more accurately through validation checking.

The type of data that is stored in a property is determined by the logical type. It is important to select the correct logical type for the type of data that you would like to store and the type of analysis that is needed. For more information about the logical types that you can choose, see Logical types.
Note: When you are deciding whether to use a single-line or multi-line string type, it is important to consider the intended use of the data and the performance of your system.

A property with the single-line string logical type is used to store text that can be used for faceting, and supports operations such as 'Starts with' and 'Ends with'. A property with the multi-line string logical type can be used to store larger blocks of information, but the values cannot be used for faceting or operations such as 'Start with' and 'Ends with'.

A property with the single-line string logical type can contain a maximum of 8000 characters in Db2 databases, or 4000 characters in SQL Server databases.

To specify a logical type:
  1. In the tab of your chosen property type, select a logical type from the Logical type list. The default logical type is Single Line String.
  2. If you select either Selected From List or Suggested From List, add entries to the Selection List. You can input each entry manually by clicking Add, or from an existing list file by clicking Import.
    Note: When you import entries from a list file:
    • They must be present in a text document (.txt).
    • They must be presented as a list with the following structure:
      entry name tab description
      entry name tab description
    • The first line of the import file is ignored.
  3. Optional: For the Single Line String, you can specify the Maximum Length.
    Note: To help reduce performance issues, the default length for single-line strings is 250 characters, increasing this limit affects performance and must be tested.