SAP Knowledge Base Article - Public

2969873 - Filter condition in string fields like ZipCode not working in the Integration Center

Symptom

You are applying some filter condition in string fields like ZipCode and this is not working (not returning your expected results) in the SuccessFactors Integration Center.

Find below one sample of filter set:

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

Environment

  • SuccessFactors HXM HCM Suite
    • Integration center

Cause

ZipCode and other string fields with all 0's (irrespective of length, like 011112) and alphabet containing ZipCode can have any combination.

For these to be filtered, regular expression should be created to match string pattern and based on that filtering can be done.

Integration Center has a limitation where we don't support many re-ex combinations/pattern.

Resolution

Achieving the use case for all 0's of any length and alpahbet containing zip code is a limitation which cannot be achieved through Integration center filters.

Keywords

SuccessFactors HXM Suite, Integration center, zipCode, string, filter not working, filter not applied, filtering, complex filters , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions