in
Description
Return true if a given value matches any value in a list of candidates,
otherwise return false.
Syntax
Like many functions in DataPrime, in supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.
- Function notation
- Method notation
in(comparand: any, value: any, ...values: any): bool
(comparand: any).in(value: any, ...values: any): bool
Arguments
| Name | Type | Required | Description |
|---|---|---|---|
comparand | any | true | The value to check |
value | any | true | The first candidate to compare against |
...values | any | true | Additional candidates to compare against |
Example
Use case: Flag membership in a predefined group
A team name can be compared against a list of department members to determine if it belongs to Engineering.
Example data
{
"team": "Developers"
},
{
"team": "Marketing"
},
{
"team": "QA Testing"
}
Example query
- Function notation
- Method notation
create is_in_engineering from in(team, 'Developers', 'QA Testing', 'Front End Engineers', 'DevOps Team')
create is_in_engineering from team.in('Developers', 'QA Testing', 'Front End Engineers', 'DevOps Team')
Example output
{
"team": "Developers",
"is_in_engineering": true
},
{
"team": "Marketing",
"is_in_engineering": false
},
{
"team": "QA Testing",
"is_in_engineering": true
}