If

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

If( cond_expr, true_expr, false_expr )
If( cond_expr, true_expr, false_expr )
If( cond_expr, true_expr, false_expr )
if_( cond_expr, true_expr, false_expr )
If( cond_expr, true_expr, false_expr )

Description

The If function evaluates and returns the true_expr or false_expr expression, depending on the value of the cond expression. If the cond expression evaluates to anything other than a Boolean, If returns an "invalid argument" error.

Any valid Fauna Query Language expression is acceptable, including null.

The If function requires three parameters, and using them is equivalent to if-then-else. This means that you cannot use If to express if-then logic. Instead, you might find the Filter function useful, as it could be used to remove documents from consideration, in bulk, that might otherwise require If logic.

Parameters

Parameter Type Definition and Requirements

cond

Boolean Expression

The conditional expression to be evaluated and tested for true or false.

true_expr

Expression

The expression or variable to return if cond is true.

false_expr

Expression

The expression or variable to return if cond is false.

Returns

The evaluation of either the true_expr or false_expr expression, depending on the evaluation of the cond expression.

Examples

The following query evaluates the cond expression, which is the condition that needs to be tested, and then determines that cond returns true. This causes the second argument, the true_expr expression, to be evaluated and returned. The third argument, the false_expr expression, is never evaluated.

try
{
    Value result = await client.Query(
        If(true, "was true", "was false")
    );
    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
StringV(was true)
result, err := client.Query(
	f.If(true, "was true", "was false"))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
was true
client.query(
  q.If(true, 'was true', 'was false')
)
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))
was true
result = client.query(
  q.if_(True, "was true", "was false")
)
print(result)
was true
If(true, 'was true', 'was false')
'was true'
Query metrics:
  •    bytesIn:  48

  •   bytesOut:  23

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 3ms

  •    retries:   0

Is this article helpful? 

Tell Fauna how the article can be improved:
Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!