Symptoms
When searching the field look up for a category field on the knowledge table with a user language, for example, Spanish, no results are shown. The issue happens only with the Category field (Reference type) in the kb_knowledge table and not any other reference type fields in the same or other tables.
The search results show up only if the category is created in that language and doesn't show up in other languages.
Steps to reproduce:
In an affected instance:
- Activate the plugins I18N:Knowledge Management Internationalization v2 plugin and Spanish Translation
- Navigate to kb_knowledge.list
- Search for a category field in the list view
- Observe that the results show up
- Switch the language to Spanish
- Now search the same category field in the list view
- Observe that no results show up in Spanish language
Actual behavior: No results show up on searching the category field in Spanish language
Expected behavior: Same results show up on searching the category field in Spanish language as it does when using English language
Release
At least Kingston and London
Cause
A field of the type "Translated Text" allows the same field to display different content based on the user's language.
In the "Category(kb_category)" table, the field "Label" is a Translated-Text. So any customized categories are not automatically translated and have to be manually done by creating a translated text label for the customized category.
Resolution
To create a translated text for the category in the kb_category table follow the steps given below:
- Navigate to sys_translated_text.list
- Create a new translated text
- Select the table name: kb_category
- Select language: Spanish
- Select Field name: label
- In the documents field again select the table kb_category
- Select the English category you want to translate
- Write the Spanish translation of that category in the values field.
- Submit
Observe that the category gets translated to the language chosen by the user.