Siebel Personalization Administration Guide > Siebel Query Language > Functions >

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 
 Published: 18 April 2003