SAP Knowledge Base Article - Public

3439992 - How does the system behave on user search result sorting preferences?

Symptom

  • When triggering blank search, some of our admins see user search result in alphabetical order and some of them see in counter alphabetical order.
  • How does the Learning system take into consideration the user search result sorting preferences?
  • Does the Learning system remember admin preferences?

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Learning Administration >
  2. Navigate to People > Users >
  3. On Users page, hit the blank search >
  4. Notice the sorting order of the user search result.

Cause

When a new column is added on the UI from "Field Chooser", (organizationID for example) and admin who is viewing the search result does the desc order/asc order, this column name (ordID) and sortOrder is stored in DB. When you come back to the user search again, the preferences stored will be picked up and user result will be shown accordingly. Now suppose from UI we remove organizationID (admin do not want to view it anymore), then in the DB the column is removed but sortOrder is still there (desc, in this case).

From the default configuration of search selector, sortByColumn is set to By Name. So, the column is picked from default configuration and sortOrder is picked by userPreference table (which is not removed when column organizationId was removed from UI), in this case descending order. Hence, this userPreference takes priority over the default configuration.

Resolution

To resolve the sorting order preference, in case you're not seeing the search result in alphabetical order, follow these steps:

  1. Go to Users and click Search (plain search without filter) >
  2. Add a column from "Field Chooser" (any column, example: organizationID, by giving last number+1 to it) > Click "Submit" >
  3. Click the new column, you will see the user result will be sorted by this column (first click is ascending order. If you click again, it would be descending) > Click once to make it ascending >
  4. Now open "Field Chooser" again and remove this new column that was added (by removing the number from it and clicking "Submit").

The sorting will now be based on userName in A-Z order. It's not necessary to perform this step every time, it will be stored as preference for this admin only.

Keywords

user, search, result, alphabetical, sorting, preferences, admin, order, how, set , KBA , LOD-SF-LMS-USR , User Entity , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To

Product

SAP SuccessFactors Learning all versions