Array expression.

Range predicates

A range predicate tests a Boolean condition over the elements of an array.

A predicate has a quantifier which determines the number of elements that need to match the condition, for the predicate to evaluate to true.

The ANY quantifier requires at least one of the array elements to match the condition.

The EVERY quantifier requires all of of the array elements to match the condition, or for the array to be empty.

The ANY AND EVERY quantifier requires all of of the array elements to match the condition, and for the array not to be empty.

Here is how to build a range predicate expression:

final expr = ArrayExpression
        // To build a range predicate you start by selecting one the
        // quantifiers and defining the variable to which the array elements
        // will be assigned.
        .any(ArrayExpression.variable('myVar'))
    // Next, you specify the array expression to evaluate the range
    // predicate against.
    .in_(Expression.property('myArray'))
    // And lastly, you specify the condition which is evaluated for each
    // array element, which should reference the previously defined variable.
    .satisfies(
      ArrayExpression.variable('myVar').equalTo(Expression.value(true)),
    );

In the condition given to satisfies, you can use a variable expression which specifies a property path, if the array contains nested collections:

final expr = ArrayExpression.variable('myVar.property')
    .equalTo(Expression.value(true));

ArrayExpression class Query Builder

Range predicates

Properties

Methods

Operators

Static Methods

cbl library