Language-dependent references

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 as language-dependent. This option is especially useful in connection while accessing external data.

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.

German language setting

English language setting

On the edit page Color, a constant is entered in the field Color, this constant has the same character string in every language for a color.

In the Language drop-down list, the corresponding language abbreviation will be selected here. In Color Title, the color that will also be shown in the table on the Collection page will be entered in its corresponding languages.

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 will be referenced by the Jeans data group.

When adding this reference, you have the ability to assign foreign keys in the Relationships dialog.

Highlight the Language primary key and click on Mark assignment.

The session variable Language will be selected as the foreign key, from which, at any time, the language key of the current language setting of the portal can be read in Intrexx.

click on Next here.

The Color Title will be selected as the data field here. To apply these settings, click on Finish.

On the Jeans edit page, the drop-down list, which allows the color to be chosen, can now be created.

The entries in the drop-down list stem from the Color Title reference field.

Here is the Jeans edit page in the browser. The correct entries will be displayed in the drop-down list depending on whether the portal is set to English or German.

German language setting

English language setting