The IN keyword checks if a list or concept set contains a specific value.
This function is SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a Yes/No value that indicates if a list or a concept_set contains a value.
value IN value_list
"Wallet" IN ([Products.Name] of [Products]) => Yes: if [Products] has a product with a name that is wallet.
value_list IN value_list
List("Wallet", "Moneyclip") IN ([Products.Name] of [Products]) => Yes: if [Products] has products with a name that is wallet and one that is moneyclip. => No: if only one of the names are in [Products]
concept IN concept_set
'Role'.'Admin' IN { 'Role'.'PowerUser', 'Role'.'Admin' } => Yes
concept_set IN concept_set
{'Lang'.'nl-NL'} IN {'Lang'.'nl-NL','Lang'.'en-US'} => Yes
{'Lang'.'de-DE', 'Lang'.'nl-NL'} IN {'Lang'.'nl-NL','Lang'.'en-US'} => No: the whole set must be contained to return true.
Last modified 1yr ago