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.
-
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.
See Also
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