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.
About this task
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 PostgreSQL and Db2 databases, or 4000 characters in SQL Server databases. In general, you should try to use single-line strings for values of up to a few hundred characters, and multi-line strings for bigger values.
Procedure
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.