In

docs model reference
1

Determines if a given value matches any value in a list of values. The result is boolean.

Function Parameters

FilterExpression

Expression to compare

Possible children:

  • Data Constant
  • Field reference
  • Function

List

A single Lookup Reference or multiple references from the following list:

  • Data Constant
  • Field reference
  • Function

Using In With a Subquery

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.

Conditions:

  1. Since it is a list we want the lookup to return, this lookup has to have the ListFilter set.
  2. 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”.