In the knowledge article list view, searching in the Category field doesn't return results when using languages other than English - Support and Troubleshooting

In the knowledge article list view, searching in the Category field doesn't return results when using languages other than English Issue  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.

Additional Information Translate the content of a translated text field