WhereClause

Represents a filter on an index or primary key.

See Also

Table.where() - the method that returns a WhereClause instance.

Sample

db.friends.where("shoeSize").between(40, 45).count(function(count) {
    console.log("I have " + count + " friends with the shoe size between 40 and 45");
});

Methods

above()

Returns a collection of objects where index is above given key

aboveOrEqual()

Returns a collection of objects where index is above or equal given key

anyOf()

Returns a collection of objects where index is equal to any of the keys in given array

below()

Returns a collection of objects where index is below given key

belowOrEqual()

Returns a collection of objects where index is below or equal given key

between()

Returns a collection of objects where index is between given boundaries

equals()

Returns a collection of objects where index equals given key

equalsIgnoreCase()

Returns a collection of objects where index equals given string-key ignoring case differencies

startsWith()

Returns a collection of objects where index starts with given string-key

startsWithIgnoreCase()

Returns a collection of objects where index starts with given string-key ignoring case differencies