SAP Knowledge Base Article - Public

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


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


  • 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.


  • SAP SuccessFactors HXM Suite
    • Integration center


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.


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


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

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

See Also

Please check the same behavior documented in our integration center handbook under the chapter "Time-Based Filters" (currently page 54, but may change in future)


Time-Based Filter not returning correct data, Time Filter, erratic, incorrect results, integration center, SAP SuccessFactors HXM Suite, IC, Time Based filters , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To


SAP SuccessFactors HXM Suite all versions