SAP Knowledge Base Article - Public

2763113 - Job Offer Odata entity return error [COE0019]Failed to retrieve result with given criteria when adding filter internal Status

Symptom

User is getting a error message " [COE0019]Failed to retrieve result with given criteria" while filtering on Internal Status of offer via API     query

Environment

 Successfactors Recruiting Management

Reproducing the Issue

Run the below query in Postman or in Web browser (It could be for all data center. In this case I have taken DC15 as an example).

https://api15.sapsf.cn:443/odata/v2/JobOffer?$filter=internalStatus eq 'Completed' 

Cause

Offer Letter Status Text (Highlighted in Yellow) is not recognized by the system while filtering on a status.

Resolution

Run the query by applying filter on InternalStatus Code.

e.g: https://api15.sapsf.cn/odata/v2/JobOffer?$filter=internalStatus eq 2

Below are the InternalStatus code of all the status of offer.

DRAFT-0

PENDING-1

COMPLETED-2

REJECTED-3

CANCELLED-4

Keywords

[COE0019]Failed to retrieve result with given criteria , KBA , LOD-SF-RCM-API , Webservices & APIs , How To

Product

SAP SuccessFactors Recruiting all versions