2395166 - Admin searching for users gets no result

In our learning instance when an admin goes to search for users (Users > Search) gets no results.

 

Successfactors Learning

Learning Management System

• login to learning.
• Switch to admin view.
• Click Users in main menu.
• Click "Search" button. Wait. No results returned.  
• Search for any particular user with User ID or Firstname or Lastname, No results returned.

This happens because of the customization done on the user search selector.

We added an extra field to the user record: External ID. To support the field, we modified the default User search selector. If you customized the default User search selector, you do not get the update to include PA_STUDENT.PERSON_ID_EXTERNAL. Add it to avoid errors when searching for user records.

Step 1: Navigate to System Admin > Configration > Search Selectors
Step 2: Find and open the selector name "User"
Step 3: Find selectClause.mainSqlClause
Step 4: Look at the end of the comma separated list of values for selectClause.mainSqlClause for PA_STUDENT.PERSON_ID_EXTERNAL
Step 5: If you cannot find PA_STUDENT.PERSON_ID_EXTERNAL at the end of selectClause.mainSqlClause, add it.

            After you have added PA_STUDENT.PERSON_ID_EXTERNAL, selectClause.mainSqlClause looks like the following. You might have added or removed cells based on your customization and we formatted this sample so that the code would fit on this page.

            Sample Code

selectClause.mainSqlClause=PA_STUDENT.STUD_ID,PA_STUDENT.EMP_STAT_ID,
PA_STUDENT.EMP_TYP_ID,PA_STUDENT.FULLTIME,PA_STUDENT.REGULAR_TEMP_ID,
PA_STUDENT.JL_ID,PA_STUDENT.JP_ID,PA_STUDENT.DMN_ID,\n
PA_STUDENT.ORG_ID,PA_STUDENT.CO_ID,PA_STUDENT.LNAME,PA_STUDENT.FNAME,
PA_STUDENT.MI,PA_STUDENT.NOTACTIVE,PA_STUDENT.ADDR,\n
PA_STUDENT.CITY,PA_STUDENT.STATE,PA_STUDENT.POSTAL,PA_STUDENT.CNTRY,
PA_STUDENT.SUPER,PA_STUDENT.HIRE_DTE,PA_STUDENT.TERM_DTE,\n
PA_STUDENT.EMAIL_ADDR,PA_STUDENT.HAS_ACCESS,PA_STUDENT.SELF_REGISTRATION,
PA_STUDENT.LOCKED,PA_STUDENT.REGION_ID,\n
PA_STUDENT.ROLE_ID,pa_stud_tp.STATUS as PROFILE_STATUS,
pa_student_fin_acct.acct_id as ACCOUNT_ID, PA_STUDENT.POS_NUM_ID,
PA_STUDENT.NATIVE_DEEPLINK_USER, PA_STUDENT.GAMIFICATION_STUD_ID,
PA_STUDENT.PERSON_ID_EXTERNAL

 

Step 6 : Click Apply Changes.

 

Admin searching for users gets no result User Search is blank User Search not resurning any result no result in user search   , KBA , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Problem

SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611