How to get field translated text using client-side script - Support and Troubleshooting

How to get field translated text using client-side script Issue  Using the following approach the user can get the translated text for a field from client-side script. This approach is applicable for any fields of type "Translated Text" or "Translated HTML".

Release All

Resolution n server code you can use GlideRecord getDisplayValue function to get the translated text for the current selected language. However, in client script the getDisplayValue function is not supported. Therefore a different approach is required. It is necessary to execute a query directly against the translation table.

Here is an example function that will perform the required lookup:

// get translation text from client script function translate(tablename,sysid,fieldname,lang) { var gr = new GlideRecord("sys_translated_text"); gr.addQuery("tablename", tablename); gr.addQuery("documentkey", sysid); gr.addQuery("fieldname",fieldname); gr.addQuery("language",lang); gr.query(); var txt = ""; if (gr.next()) txt = gr.value; return txt; } It is necessary to pass the following parameters: tablename - the name of the table that you want the translated text for fieldname - the name of the translated field sysid - the sys_id of the record that you want to find the translation lang - the language code eg. "fr" = french "ja" = japanese

If no translation is found, a null string is returned.

Example usage:

eg. to get the french translation of the description of a specific catalog item:

var txt = translate("sc_cat_item","060f3afa3731300054b6a3549dbe5d3e","short_description","fr"); Related Links Note: in client script there is the global variable g_lang that evaluates to the code of the user's current session language. This can be useful when wanting to translate a field value into the current language.

For example of equivalent on server side code see following knowledge article

KB0749769 How to get field translated text from server script code