SAP Knowledge Base Article - Public

2729338 - Integration Center: How to Filter on Custom & Non-Filterable Fields

Symptom

In some cases, you will need to filter data in an Integration Center job, based the following:

  • A standard field, that is not filterable [filterable=false]
  • A custom field, that was added to a standard entity / object

"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 BizX
  • Integration Center

Reproducing the Issue

  1. Attempt to filter Integration Center output based on a non-filterable standard field (e.g. Default Locale in User)
  2. Attempt to filter Integration Center output based on a custom field, that was added to a standard entity / object

Cause

  • Filtering data based on standard / non-filterable fields and custom fields, added to standard entities / objects is not possible.
  • This is a limitation of OData which extends to Integration Center.

Resolution

There is a workaround that meet both above scenarios.

We can use the 'Calculated Filter' functionality available in Integration Center to:

  • Filter Integration Center output based on a non-filterable / standard field 
  • Filter Integration Center output based on a custom field, that was added to a standard entity / object

 

Taking the standard / non-filterable field 'Default Locale' from the User entity as an example:

 1.PNG

Perform the following:

 

Step 1: Add the desired (non-filterable / custom) field to the Configure Fields preview screen in Integration Center

step1.PNG

 

Step 2: Navigate to Filter & Sort > Advanced Filters > Calculated Filter (Button)

Step2.PNG

 

Step 3: Choose the 'IF/Then/Else' operation and associate the field that we added in Step 1 - (Default Locale from User)

Step3.PNG

 

Step 4: Input the desired comparison & value (Default Locale from User is equal to en_GB)

Step4.PNG

 

Step 5: In the 'Then' step of calculation, leave field value blank (this well let the value pass through to the integration center job preview)

Step5.PNG

 

Step 6: In the 'Else' step of calculation, enter 'False' (this will stop undesired values from passing through to the job preview) & click 'Save

Step6.PNG

 

Output + Finished Calculation:

calc_output.png

**PLEASE NOTE:

  • You can apply use this workaround to filter on ONE field only
  • This cannot be used to filter on multiple non-filterable / custom fields 

See Also

Integration Center Guide - Creating Outbound Integrations

Keywords

Filter, Non-filterable, Custom fields, API, OData API, Integration Center, filterable=false , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HXM Core all versions