Getting Started

Basics

Query Modifiers

.where() .sort()

Query Predicates

.equals() .notEquals() .exists() .notExists() .startsWith() .endsWith() .contains() .greaterThan() .lessThan() .between() .outside()

Query Executors

.read() .first() .last() .count() .sum() .average() .min() .max() .update() .delete()

Login Methods

.exists() .login() .logout()

Instance Methods

.read() .delete()

Instance Login Methods

.login() .logout() .changePassword()

Misc

Back.then() Back.saved() Back.user() Back.eachProperty() Back.eachDescendant() IFile Property LoginResult

Predicates.outside()

Filters the query based on whether the value of the applicable NumberProperty or DateProperty is outside the specified value range. This method is the opposite of between().

Employees
	.where(Employee.salary).outside(1000, 1500)
	.read(employees =>
	{
		// employees is an array of Bunny objects 
		// that have a salary ranging from $1000 to $1500.
	});

var lowerBound = new Date().setYear(new Date().getYear() + 2);
var upperBound = new Date().setYear(new Date().getYear() + 1);

Companies
	.where(Company.foundingDate).outside(lowerBound, upperBound)
	.read(companies =>
	{
		// companies is an array of Company objects that 
		// have a foundingDate between one and two years ago.
	});
	

Method signature (TypeScript)

static outside(lowerBound: number, upperBound: number);
static outside(lowerBound: Date, upperBound: Date);

Details

lowerBound
The number or Date value that the stored value may be less than in order to match.
lowerBound
The number or Date value that the stored value may be greater than in order to match.
returns
An object containing all of the Query Modifiers and Query Executors.

Availability:

This predicate is available when the previous .where() modifier contains a property of one of the following types: