whereNotBetween method

Query<T> whereNotBetween(
  1. String field,
  2. Object lower,
  3. Object upper
)

Adds a WHERE NOT BETWEEN predicate.

This method adds a WHERE field NOT BETWEEN lower AND upper clause to the query.

Example:

final usersOutsideAgeRange = await context.query<User>()
  .whereNotBetween('age', 18, 30)
  .get();

Implementation

Query<T> whereNotBetween(String field, Object lower, Object upper) {
  final resolved = _resolvePredicateField(field);
  return _appendPredicate(
    FieldPredicate(
      field: resolved.column,
      operator: PredicateOperator.notBetween,
      lower: lower,
      upper: upper,
      jsonSelector: resolved.jsonSelector,
    ),
    PredicateLogicalOperator.and,
  );
}