SAP Knowledge Base Article - Public

2726841 - How to use filter option on jobReqPostings/postingStatus fields in ODATA API - Recruiting Management

Symptom

While running a ODATA API Query to fetch the details of the Job Requisition, you will see the details of the Job Posting status as Updated.

Posting Status section.png

However if you try to filter the Requisition with Posting Status as "Updated", it will throw an error

https://apisalesdemo4.successfactors.com/odata/v2/JobRequisition?$jobReqPostings,status,recruiter,jobReqLocale,mrPostingType,jobType,orgeh5 &$format=json&$filter=jobReqPostings/postingStatus eq 'Updated'

Error message :

Failed to retrieve result with given criteria.

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

Environment

SAP SuccessFactors Recruiting Management

Cause

This is the Expected behavior

Resolution

At the code level the Posting Statuses are mapped to the Numeric value 

  • POST_FAILED (0, "Failed"),
  • POSTED_SUCCESS (1, "Success"),
  • UPDATED_SUCCESS (2, "Updated"),
  • DELETED_SUCCESS (3, "Deleted"),
  • POST_PENDING (4, "Pending"),
  • REPOST_PENDING (5, "Repost_Pending"),
  • REPOSTED_SUCCESS (6, "Repost_Success"),
  • POST_EXPIRED (7, "Expired");

For Example, if you need filter the Job Requisition based on Posting Status "Updated", the query needs to be like this:

https://apisalesdemo4.successfactors.com/odata/v2/JobRequisition?$jobReqPostings &$format=json&$filter=jobReqPostings/postingStatus eq 2

Keywords

jobReqPostings, postingStatus, Failed, retrieve, the, result, given, criteria , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem

Product

SAP SuccessFactors Recruiting all versions