Determines if a given value matches any value in a list of values. The result is boolean.
Expression to compare
A single Lookup Reference or multiple references from the following list:
You can use this function to filter from a list of values provided by a subquery. This can be achieved by supplying a Lookup Reference in the List parameter.
- Since it is a list we want the lookup to return, this lookup has to have the ListFilter set.
- Typically you will want to substitute a parameter from the lookup with a field from the current entity. In that case you need to add a parameter mapping under the lookup reference. You will typically add a field reference (the field from the current entity you will pass as a parameter) and name the mapping as a parameter from the lookups ListFilter filter set. Since this will be rendered as an SQL subquery, you will need to add a “lookup” prefix to the parameter’s name. E.g. “lookupBusinessPartner_parId”.