Symptom
In this document we will go through the process of filtering an Integration Center Job using the 'Is Deleted' filter. Sometimes, this filter can cause issues and may return no data (even when there is data present) when filtering a report.
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
Reproducing the Issue
1. Query a starting entity - take JobRequisition as an example.
2. Add the 'Is Deleted' field to the Integration Center Job.
3. Attempt to use Filter Functionality - filtering by 'Deleted'
4. No data returned in output:
Cause
Filter values for the 'Is Deleted' standard enitity are:
-
0 - Not Deleted
- 1 - Deleted
- Example query: https://apisalesdemo4.successfactors.com/odata/v2/JobRequisition?$format=JSON&$select=jobReqId,deleted&$filter=deleted ne '0'
Resolution
Enter the values 0 or 1 in the Filter Functionality option in Integration Center - avoid 'Deleted or 'Not Deleted'.
See Also
Integration Center, Is Deleted, Filter, Filter Options, Integration Center job
Keywords
KBA , LOD-SF-RCM-INT , Integration Center & Intelligent Services , How To
SAP Knowledge Base Article - Public