SAP Knowledge Base Article - Public

3587348 - Programs search results not sorting by Start/End date

Symptom

When sorting the Program Search results by Start or End date programs are not getting displayed correctly 

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Open Programs and search. 
  2. Select the date and time records to sort the results.
  3. The Programs do not sort by Start/Date.

Cause

Sorting for Program is only supported for program ID, status, type and period by default.

To sort by any other fields we need add configurations in search selector.

Resolution

To sort the search results by Start/End date you will need to add the following configuration 

Search Selector > Program > Edit

Add below configs

  • orderByClauses[By\ StartDate]=START_DTE
  • orderByClauses[By\ EndDate]=END_DTE

    and for 
  • searchResultColumns.startDate.orderbyOptionRef= null and 
  • searchResultColumns.endDate.orderbyOptionRef=null

change it to

  • searchResultColumns.startDate.orderbyOptionRef=By StartDate
  • searchResultColumns.endDate.orderbyOptionRef=By EndDate

Keywords

SAP SuccessFactors Learning, Program Sorting, Start Date, End Date, search selector. , KBA , LOD-SF-LMS-PRO , Programs , Problem

Product

SAP SuccessFactors Learning all versions