SAP Knowledge Base Article - Public

3499349 - Why is Keyword search criteria not working in Japanese and Chinese? - SuccessFactors Learning

Symptom

  • Admin enters Japanese or Chinese charaters in Keyword search criteria. However, system returns no result.
  • On the other hand, when admin searches for the same characters in Item Title criteria, results are displayed without problem.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

1. Learning Administration > Access any Assignment Profile > Items tab > Add

2. Keyword search criteria displays > Search for keyword in Japanese or Chinese > No result is displayed.

3. Search for the same Japanese or Chinese characters with item title criteria> Results display without problem.

Cause

Keyword search criteria searches for any of the given words in item ID or Item Title.

In addition, the keyword has to be the complete word and not like a part of the word being searched. 

Logic In English: 

For example, there is an item whose title is "English Test Item".

Keyword search criteria will only return result when admin searches for complete words, that are "English", "Test" and "Item".

Keyword search criteria will not return result when admin searches for incomplete words, such as "Eng".

Logic in Japanese and Chinese: 

Unlike English, in Japanese and Chinese there is no space to be used between words.

Take "Test Item" as example, in Chinese it's "测试课程". 

"测试" (Test) is a word and "课程" (Item) is another. They're linked up as a phrase without any space and it's the correct grammar in Chinese.

Thus, "测试" and "课程" may be used for keyword searching by admin.

Why does this mechanism not work in Japanese and Chinese?

Take the same example.

System will only identify "测试课程" as a complete word because it's working based on English grammar logic.

Keyword criteria only identifies separate words when there is space or special characters. 

As a result, "测试" and "课程" will be identified as incomplete words and will not return any result.

Resolution

PM confirmed that the application is working this way currently.

As a workaround to retrieve the results for Japanese and Chinese customers, search selector Full text search query can be modified to append another condition.

Below are the steps for the workaround, the same applies to other entities as well.

  1. Go to System Administration > Configuration > Search Selectors > Search for 'Component'
  2. Edit Component Search Selector -> Navigate to the setting 'criteria.FULL_TEXT_HANA_SEARCH.fullTextSearchQuery=' and replace the original query with below changed query (highlighted in bold is the newly added condition in the query).

1=1/*HANAVIEW_EXPRESSION and (contains ((PV_COURSE.cpnt_id), '($VALUE$)' ,$FULL_TEXT_SEARCH_TYPE$ , WEIGHT(10)) or contains ((I18N_LOCALIZED_LABEL.LABEL_VALUE), '($VALUE$)' ,$FULL_TEXT_SEARCH_TYPE$ , WEIGHT(5)) or contains ((pa_cpnt_user.USER_VALUE), '($VALUE$)' ,$FULL_TEXT_SEARCH_TYPE$ , WEIGHT(1)) or contains ((I18N_LOCALIZED_LABEL2.LABEL_VALUE), '($VALUE$)' ,$FULL_TEXT_SEARCH_TYPE$ , WEIGHT(1))  OR (I18N_LOCALIZED_LABEL.LABEL_VALUE) LIKE '%$LIKEVALUE$%' ) */

Keywords

Language Locale, grammer logic, space, special character, item search , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-ITE , Items , Problem

Product

SAP SuccessFactors Learning all versions