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:
-
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.
-
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.
- 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.
