Skip to main content

if

Description

Return one value if a condition is true, otherwise return an alternative value.

Syntax

Like many functions in DataPrime, if supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

if(condition: bool, then: any, else: any?): any

Arguments

NameTypeRequiredDescription
conditionbooltrueCondition to evaluate
thenanytrueValue to return if the condition is true
elseanyfalseValue to return if the condition is false

Example

Use case: Add a flag based on whether an IP belongs to a subnet

If an IP is in the 10.0.0.0/8 range, mark it with a flag. This avoids recalculating the condition multiple times.

Example data

{
"ip": "10.8.0.8"
}

Example query

create is_in_10_subnet from if(ipInSubnet(ip, '10.0.0.0/8'), true, false)

Example output

{
"ip": "10.8.0.8",
"is_in_10_subnet": true
}
Was this page helpful?