SAP Knowledge Base Article - Preview

2982901 - SFAPI Compound Employee error Invalid SFQL! Error: Invalid WHERE clause. Function "to_Date" or "to_DateTime" is necessary for "last_modified_on" after 2H 2020 release

Symptom

You are running SFAPI CompoundEmployee queries like the sample below and you are getting the respective error in the response.

The query executed was in FULL MODE and you observed this error in 2H 2020 (b2011) release.

Request:

  • SELECT person,email_information,employment_information,job_information,personal_information FROM CompoundEmployee WHERE last_modified_on>=('2020-10-01T00:00:00Z')

Response:

  • Invalid SFQL! Error: Invalid WHERE clause. Function "to_Date" or "to_DateTime" is necessary for "last_modified_on". Usage Example: to_date('01/07/20', 'DD/MM/YY') or to_DateTime('2020-06-07T01:00:00Z')


Read more...

Environment

  • SAP SuccessFactors HXM Suite
    • CompoundEmployee API in Full Mode

Product

SAP SuccessFactors HCM Suite all versions

Keywords

  • Invalid SFQL! Error: Invalid WHERE clause. Function "to_Date" or "to_DateTime" is necessary for "last_modified_on". Usage Example: to_date('01/07/20', 'DD/MM/YY') or to_DateTime('2020-06-07T01:00:00Z'), SFAPI CompoundEmployee, CE, SFAPICE, 2H 2020 SF release, b2011, 2011, query, full mode, delta, last_modified_on
, KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.