SAP Knowledge Base Article - Public

2798710 - How to filter using wildcard filter expression in Integration Center (%, *, etc.,)

Symptom

How to use a wildcard filter expression in Integration Center?

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

Resolution

See the example scenario below using '%' in filter. (note : '*' is not supported)

  1. 1. In username field from User Entity, you want to filter all usernames with 'win' string/expression, whether in the start,middle or end of the string field valu

    KBA1.jpg

  2. Go to Advanced Filter in 'Filter and Sort' Tab. Use, Operation 'Is Like' and Append % on start and end of your keyword. e.g. %win%.

    KBA2.jpg

  3. See Results filtered.

    KBA3.jpg

Note: The field value you have put in filter like 'win' in the above example is case sensitive, you can add more expressions by adding another filter 'is like' with operation OR.

See Also

2742107 - Integration Center: Frequently asked questions

Integration Center Guide

Keywords

wildcard, %, filter, string filter, wildcard filter, integration center, custom filter, * filter, http filter, like, is like , KBA , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-INC-FWK , Integration Center UI Framework , LOD-SF-INT-INC , Integration Center , How To

Product

SAP SuccessFactors HXM Suite all versions