SAP Knowledge Base Article - Public

2174554 - Downloading Search results does not show all records

Symptom

  • When using the "Download Search results" function in any of the search wizards in LMS Admin. For example, in User Search:

download search results_u.jpg

  • In the downloaded excel file, you only see the same amount of records every time even though there are a higher number of total records in the database

download search results1_u.jpg

Environment

SAP SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

As an example, you can use the search wizard in Users

  1. In the LMS Admin, Open Users.
  2. Perform a blank Search
  3. Click "Download Search Results"
  4. Open the Excel file downloaded and observe the number of records downloaded to the file.

Cause

The reason why this function always only returns the same number of records is due to the value set for the Parameter "resultMaxRowAllowed". Whatever this value is set to, a search will only ever return that value even if there are more records in the database.

Resolution

  1. Go to System Admin
  2. Configuration
  3. System Configuration
  4. Edit the Configuration "SEARCH"

download search results2_u.jpg

  1. At the very start of this config file, you will see the parameter "resultMaxRowAllowed". Change this to another value.
  2. Save the new value by clicking on Apply Changes.

download search results3_u.jpg

  1. Run the search again and download the results. You will find that, it will return the value that you set for this parameter.

See Also

2470848

Keywords

LMS, resultMaxRowAllowed, Download Search Results, Downloading Search results does not show all records, excel, Microsoft Excel, , KBA , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem

Product

SAP SuccessFactors Learning all versions