Operators: $where

Running JavaScript code to select documents.

🪶 The $where
  • operator allows you to run JavaScript code to select documents that meet a custom condition.


    Database: Client > model: Users

    Here we will simulate a database with the Users collection:
    1
  • COLLECTION:
  • Users > [
    2  
  • {
  • name:
  • "Chris Axxwell",
  • nick:
  • "Chris",
  • age:
  • 27
  • }
  • ,
    3  
  • {
  • name:
  • "Chris Buckman",
  • nick:
  • "Chris",
  • age:
  • 28
  • }
  • ,
    4  
  • {
  • name:
  • "Santiago Smith",
  • nick:
  • "Lollipop",
  • age:
  • 24
  • }
  • ,
    5  
  • {
  • name:
  • "Justin Dacker",
  • nick:
  • "Justin",
  • age:
  • 22
  • }
  • ,
    6  
  • {
  • name:
  • "Chris Morgan",
  • nick:
  • "Mor",
  • age:
  • 25
  • }
  • ,
    7   ...
    8]

    Query the above database:

    1
  • import
  • MerlinDB,
  • {
  • Schema
  • }
  • from
  • "@chrisaxxwell/merlin-db";
    2
  • //Or if you are using 'merlindb.max.js' just call 'new MerlinDB()';
  • 3
    4
  • const
  • merlin =
  • new
  • MerlinDB(
  • )
  • ;
    5merlin
  • .connect(
  • "Client"
  • )
  • ;
    6
  • var
  • clientModel = merlin
  • .model(
  • "Users", <userSchema>
  • )
  • ;
    7
    8
  • //$where: <function>;
  • 9clientModel
  • .find(
  • {
  • 10  
  • $where:
  • function (
  • )
  • {
  • 11      return this.name === 'Chris Axxwell';
    12  
  • }
  • 13
  • }
  • )
  • .then(
  • e =>
  • {
  • 14   console
  • .log(
  • e
  • )
  • ;
    15  
  • //returns:
  • 16   [
    17      
  • {
  • name:
  • "Chris Axxwell",
  • nick:
  • "Chris",
  • age:
  • 27
  • }
  • ,
    18      ...
    19   ]
    20
  • }
  • )