A Dictionary in Combinum is a table with a key column and a number of value columns.
The key column provides fast lookup for values based on keys which can be of the data type double, integer and string. The values columns are defined by name and data type with Boolean, double, integer and string as available types.
A row of a dictionary is called a Dictionary entry and consists of a value for the key and optional values for each value column.
Used for many purposes
Dictionaries can be used for many different purposes and below are just a few examples:
•Enabling users to do a selection from a table interface, see Data Selector.
•Lookup of data that is used in rules or calculations e.g. freight costs, installation hours, wattage and travel allowance. See also Large datasets in rules.
•Interpolation between data points.
•Text repositories used in reports.
•Mapping image titles to product models.
Settings
Dictionaries have the following settings:
Setting name |
Description |
|---|---|
Name |
Name of dictionary used for referral in expressions. Note! Name is an identifier which means that they must start with a letter or underscore and may only contain letters (a..z, A..Z), numbers (0..9) and underscore (_). The Swedish characters åäöÅÄÖ are also allowed. |
Key data type |
Data type for key values with String, Double or Integer as possible values. The default is String |
Columns of a dictionary have the following settings:
Setting name |
Description |
|---|---|
Name |
Name of dictionary column used for referral in expressions. Note! Name is an identifier which means that they must start with a letter or underscore and may only contain letters (a..z, A..Z), numbers (0..9) and underscore (_). The Swedish characters åäöÅÄÖ are also allowed. |
Data type |
Data type for column values with Boolean, Double, Integer or String as possible values. The default is String |
Dictionary entries have the following settings:
Setting name |
Description |
|---|---|
Key |
The key of the dictionary entry. Every key must be unique within a dictionary. |
Value (for each column) |
The column value of the dictionary entry. |
