Siebel Personalization Administration Guide > Functions >

Translation Functions


Table 36 lists the translation functions. See also Functions.

Table 36.  Translation Functions
Function
Description

LookupTransVal (lang_ind_code, table, type)

For a multilingual list of values, given a language independent code, translation table (must be S_LST_OF_VAL), and LOV type, returns the display value.

For example:

LookupTransVal ("Mr.", "S_LST_OF_VAL", "MR_MS"

returns "Mr."

LookupTransCode (display_value, table, type)

For a multilingual list of values, given a display value, translation table (must be S_LST_OF_VAL), and LOV type, returns the language independent code.

For example:

LookupTransCode ("Mr.", "S_LST_OF_VAL", "MR_MS"

returns "Mr."

LookupTranslation ([field])

For the new multilingual data feature. Takes a field as an argument, and if the field has a translation, returns the translation. Otherwise returns the value of the field.

For example:

LookupTranslation([Name])

returns "Sam" if the current language is English.

Preference (category, pref_name)

Finds the user preference for the category and preference name specified.

Preference ("User Interface", "StyleSheet")

returns the user-specified style sheet preference.

LoginName()

Returns the login ID of the logged in user.

Siebel Personalization Administration Guide