1. Configuring Siebel Business Applications
  2. Searching a Multilingual List of Values

Searching a Multilingual List of Values

Searching a multilingual list of values (MLOV) can consume significant resources because this search requires a join to the S_LST_OF_VAL list of values in the SQL code. To improve performance if many records and multiple languages exist, you can use the Fieldname.TransCode function in the Search Specification property of the business component. This function gets the untranslated language-independent code (LIC) from a column in the base table instead of getting the display value in the current language. It uses the following format:

[Fieldname.TransCode] = 'lang_ind_code'

where:

  • TransCode is case-sensitive. You cannot use the following formats:

Fieldname.Transcode

Fieldname.transcode