Determining the Language (Columns) in the Model
In Framework Manager, you can insert a macro in the
SQL of the data source query subject to return a specific column
of data. The query subject uses the macro to apply the locale setting
and to return a language code. The locale specifies linguistic information
and cultural conventions for character type, collation, format of
date and time, currency unit, and messages.
The macro, runLocale, uses a parameter map to convert the user’s desired content language into a complete or partial column name. This column name is then substituted in the SQL before the query runs.
Because the samples databases use a language code as the suffix for the column name, the macro uses a parameter map to convert valid run locales into a language code and then concatenates the language code to the base column name.