Symptom
You wish to know why, when applying this filer hiringNotCompleted = 'false' with a period delta query you are receiving this error: Invalid SFQL! Error: Invalid WHERE clause. "hiringNotCompleted" is not supported in query mode "periodDelta", cause: org.apache.cxf.binding.soap.SoapFault: SFAPI Domain Error!
Environment
SAP SuccessFactors Compound Employee API
Cause
Expected behaviour
Resolution
As explained in our Compound Employee API Guide , the WHERE query supports hiringNotCompleted for delta transmission, but not period delta.
As a potential workaround, you could filter on attribute hiringNotCompleted after fetching the payload.
Should you have a strong business requirement, please submit an enhancement request via the Influence channel. The link to Influence is http://influence.sap.com/successFactors
See Also
SAP SuccessFactors Compound Employee
3050542 CompoundEmployee: company filter not respected in Global Assignment (job_information)
Keywords
Invalid WHERE clause. "hiringNotCompleted" is not supported in query mode "periodDelta", period delta, perioddelta, delta, hiringNotCompleted, Invalid SFQL! Error: Invalid WHERE clause, API, CompoundEmployee, Compound, Compound Employee, CE , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , Problem