How to filter on 'null' values when building/using an integration 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.
SAP SuccessFactors Recruiting Management
Reproducing the Issue
When filtering on 'null' values in Integration Center, unexpected results may be received.
The 'null' (empty) value is considered separately from any other value in a field.
This is the behaviour of 'null' when used to filter the results:
Using 'is equal to null' as a filter will return all the records with 'null' values for the selected property
Using 'is not equal to null' as a filter will return all the records with a recorded value for the selected property
Using 'is not equal to X' will return all the values not equal to X BUT not the 'null' results. This basically selects all the records with a non-null value not equal to X. To select all the records not equal to X, you would need to use a filter like this:
The first statement will select all non-null values not equal to 'Complete', the second statement will select all 'null' values.
Integration Center, filter, null , KBA , LOD-SF-RCM-INT , Integrations & Intelligent Services , How To