If data groups with more than one
primary key are referenced and
values of a session variable are used in the
foreign key, then a reference
can be implemented language-dependently. This option is especially useful
when accessing
external data.
2. Example
In the following example, a jeans collection will be managed. If a user
switches the portal's language to English, then the colors of each model
will be displayed in the correct language.
On the "Color" edit page, a constant is entered in the "Color title" field;
this constant has the same character string in every language for a color -
"BLACK" for
"schwarz" in German and "black" in English.
The corresponding language abbreviation
is selected in the "Language" drop-down list.
In the "Color" field, the color can be entered in the respective language
as it will be shown on the "Collection" page.
The structure of the application consists of the
data groups
"Color" and "Jeans", whereby the "Color" data group contains two
primary keys ("Color" and "Language").
The "Color" data group is
referenced by the "Jeans" data group.
When creating the
reference via the
properties of the "Jeans" data group,
the foreign keys can be assigned.
Highlight the "Language" primary key and then click on
"Edit".
The session variable "Language" will be selected as the foreign key. This will
provide the language code of the current portal language setting at any time.
Click on "Next".
The "Color title" is selected as the data field here. To apply these settings
click on "Finish".
The entries of the drop-down list on the "Jeans" edit page come from the
reference field "Color title".
Here is the "Jeans" edit page in the browser. The correct entry is shown
in the corresponding language in the drop-down list.