SAP Knowledge Base Article - Public

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

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

    KBA1.jpg

  2. Go to "Advanced Filters" in "Filter and Sort" tab, select operation "is like" and append "%" at the start and at the 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.

Also, please note that an "is not like" filter is not supported.

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 , Integration Center , LOD-SF-INT-INC-FWK , Integration Center UI Framework , How To

Product

SAP SuccessFactors HCM Suite all versions