SAP Knowledge Base Article - Public

3228920 - Invalid WHERE clause. "hiringNotCompleted" is not supported in query mode "periodDelta"

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 , Known Error

Product

SAP SuccessFactors HXM Suite all versions