Language-dependent references

Multilingual portals

1. General

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.

3. More information

Multilingual portals