SAP Knowledge Base Article - Public

3282970 - Edit Learning History search returns an application error


When admin is trying to perform a search under Manage User Learning > Edit Learning History, an application error is presented even though the relevant search selector config file is not customized.

Error message = The straight column name [column_name] is not present in the projectionwith original orderBy [s.LNAME, s.FNAME, a.COMPL_DTE]

Example screenshot:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP SuccessFactors Learning

Reproducing the Issue

  1. Go to Manage User learning
  2. Edit Learning History
  3. Search 
  4. Error is presented


When SearchSelectorSortingAtEnd is set to 'true' on the backend, some use cases in the select query were not considered by the code logic.


Engineering created a code correction and this will be fixed in b2305 as part of LRN-138883.

In the meantime, if you are experiencing the same behaviour, please submit a ticket to LOD-SF-LMS-ADM component by referencing this KBA and ask Support to modify the SearchSelectorSortingAtEnd value from 'true' to 'false' in your tenant.


edit learning history, application error, search, searchSelectorSortingAtEnd, LRN-138883 , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem


SAP SuccessFactors Learning 2205 ; SAP SuccessFactors Learning 2211