3355773 - Multiple "is not equal to" rule is not working for lookup function

Symptom

Lookup function is used to look up values from a Metadata Framework object that serves as a lookup table.

However, multiple "is not equal to" rule is not working for lookup function.

Environment

SAP SuccessFactors Employee Central

SAP SuccessFactors MetaData Framework

Cause

This is a current restriction in lookup function.

Resolution

In the lookup function, you can't define a restriction for the same field with the same operator in the Where condition.

For example:

Username is not equal to “Name1”
Username is not equal to “Name2”

In such cases, only the first restriction is taken into account, the subsequent restrictions are ignored.

Keywords

Lookup() function, is not equal to condition, validation only works for first condition, business rule, look up values from a Metadata Framework object, lookup table , KBA , LOD-SF-EC-JOB-RUL , Job Info Business Rules , LOD-SF-MDF-RUL , Custom Oject based Business Rules , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors Platform all versions