SAP Knowledge Base Article - Public

2846674 - Numeric values that are stored on a text field type is not being sorted correctly - Recruiting Management


System does not sort numeric values that are stored in a text field type properly in Candidate Summary Workbench.

 “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 Recruiting Management

Reproducing the Issue

  1. Admin Center > Recruiting > Job Requisition
  2. Select any Job Requisition with Candidates > Access Candidate
  3. Sort a column with numeric values.


<field-definition id="XXXX" type="text" required="false" custom="true" public="false" readOnly="false" anonymize="true" forward-intact="true" sensitive="false">
<field-label mime-type="text-plain"><![CDATA[Numeric Value: ]]></field-label>




There could be several root cause on why numeric values is not sorted correctly when accessing Candidate Summary Workbench but this KBA caters only numeric values that are  stored on a text field.

Sorting numeric values that are stored on a "text" field type will sort the data based on the first  digit of the value instead of the numeric value.


This behavior is expected. If you decide to use the number type, we don't advise to just update the field type as it will cause error for existing data. You should create a new field with the correct field type.

If you think that this functionality could be improved kindly please submit an enhancement request through our Influence page.

See Also

2090228 - How to submit enhancement requests for SAP SuccessFactors products


Number, Sort, Order, Text, Candidate, Workbench, String, Assessment, Score, Value , KBA , LOD-SF-RCM-CAN , General Candidate Issues (not Offers, not Profiles) , Problem


SAP SuccessFactors Recruiting all versions