SAP Knowledge Base Article - Public

2430737 - How does the 'Time Based Filter' in Integration Center work?

Symptom

  • Adding a 'Time-Based Filter' in an Integration Center Interface built using the 'SFOData.User' entity as the Starting entity as follows-

Capture1.JPG

  • Now this interface is returning some records even though the lastModifiedDateTime field of the User entity does not fulfill the above filter criteria.
  • For example: As per the above filter, the records with the lastModifiedDateTime field value greater than '2017-02-16T13:00:00' should be returned but we see in the final output file that records with lastModifiedDateTime prior to '2017-02-16T13:00:00' are also returned.

Environment

Successfactors

Cause

When we add a Time Based Filter as above, it automatically adds the same 'lastModifiedDateTime' field filter for all the navigation entities used.

So for example, if you are using navigations to manager, hr structures, then the complete filter will be as follows-

filter=lastModifiedDateTime ge datetimeoffset'2017-02-16T13:00:00.000Z' 
OR  manager/lastModifiedDateTime ge datetimeoffset'2017-02-16T13:00:00.000Z' 
OR hr/lastModifiedDateTime ge datetimeoffset'2017-02-16T13:00:00.000Z'

And so, even though the filter condition of the first filter(lastModifiedDateTime ge datetimeoffset'2017-02-16T13:00:00.000Z' ) is not satisfied by a record, it can still be returned if any of the other two conditions fulfill the criteria.

Resolution

If you want to use only the direct 'SFOData.User' entity field 'lastModifiedDateTime' in the filter, then you can use it as follows-

Capture2.JPG

And then the filter clause of the query will be created as follows-

filter=lastModifiedDateTime ge datetimeoffset'2017-02-16T13:00:00.000Z' 

Keywords

  • Time-Based Filter not returning correct data
  • Integration Center Time Filter
, KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1611 ; SAP SuccessFactors HCM Suite all versions