SAP Knowledge Base Article - Public

2929120 - Filtering 'EMEvent' records by 'Event Time' doesn't work - Integration Center

Symptom

  1. You have an outbound integration in IC that fetches execution manager event (EMEvent) records;
  2. A filter is configured to compare the 'Event Time' field to the last run time variable (LASTRUNTIME);
  3. There are records in the output which should've been filtered out.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
    • Integration Center

Reproducing the Issue

  1. Set up a filter as below:

  2. Run the integration and observe records in the output that don't respect the filter:

Cause

Since the LASTRUNTIME variable is assuming 'date' format instead of 'datetime', the time portion of the variable is being defaulted to '00:00:00' for comparison.

This is expected behavior. LASTRUNTIME assumes 'datetime' format only when compared to audit fields, such as "last modified datetime" and "created datetime". For other DateTimeOffset fields, only the date part is considered as per design.

Resolution

The following workaround can be tested at your own discretion, since it does not comply with the standard design:

  1. Change the field from 'Event Time' to one of type string, such as 'Event Description' or 'Event Name';
  2. Manually edit the value to 'datetime';


  3. Change the field back to 'Event Time' and the 'datetime' change will remain;
  4. Validate the integration's behavior.

Keywords

success factors, query, not working, incorrect, entity, filter, wrong result, incorrectly, behavior , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , Problem

Product

SAP SuccessFactors HXM Suite all versions