range

Sample Index

The following index definition named default indexes the runtime field only in the movies collection.

1
{
2
  "mappings": {
3
    "dynamic": true
4
  }
5
}

1
{
2
  "mappings": {
3
    "dynamic": false,
4
    "fields": {
5
      "runtime": {
6
        "type": "number"
7
      }
8
    }
9
  }
10
}

Sample Query

The following query searches for movies with a runtime greater than or equal to 2 and less than or equal to 3. It includes a $limit stage to limit the output to 5 results and a $project stage to exclude all fields except title and runtime.

1
db.movies.aggregate([
2
  {
3
    "$search": {
4
      "range": {
5
        "path": "runtime",
6
        "gte": 2,
7
        "lte": 3
8
      }
9
    }
10
  },
11
  {
12
    "$limit": 5
13
  },
14
  {
15
    "$project": {
16
      "_id": 0,
17
      "title": 1,
18
      "runtime": 1
19
    }
20
  }
21
])

{ "runtime" : 3, "title" : "Dots" }
{ "runtime" : 3, "title" : "Sisyphus" }
{ "runtime" : 3, "title" : "The Fly" }
{ "runtime" : 2, "title" : "Andrè and Wally B." }
{ "runtime" : 2, "title" : "Luxo Jr." }

Sample Index

The following index definition named default indexes the runtime field in the movies collection.

1
{
2
  "mappings": {
3
    "dynamic": true
4
  }
5
}

1
{
2
  "mappings": {
3
    "dynamic": false,
4
    "fields": {
5
      "runtime": {
6
        "type": "number"
7
      }
8
    }
9
  }
10
}

Sample Query

The following query searches for all movies with a runtime less than or equal to 2. It includes a $limit stage to limit the output to 5 results and $project stage to:

• Exclude all fields except title and runtime

• Add a field named score

1
db.movies.aggregate([
2
  {
3
    "$search": {
4
      "range": {
5
        "path": "runtime",
6
        "lte": 2
7
      }
8
    }
9
  },
10
  {
11
    "$limit": 5
12
  },
13
  {
14
    "$project": {
15
      "_id": 0,
16
      "title": 1,
17
      "runtime": 1,
18
      score: { $meta: "searchScore" }
19
    }
20
  }
21
])

{ "runtime" : 1, "title" : "Blacksmith Scene", "score" : 1 }
{ "runtime" : 2, "title" : "Andrè and Wally B.", "score" : 1 }
{ "runtime" : 2, "title" : "Luxo Jr.", "score" : 1 }
{ "runtime" : 1, "title" : "The Kiss", "score" : 1 }
{ "runtime" : 1, "title" : "Dickson Experimental Sound Film", "score" : 1 }

Sample Index

The following index definition named default dynamically indexes all fields, including the accounts field, which is an array of numeric values.

{
  "mappings": {
    "dynamic": true
  }
}

Sample Query

The following query searches for customer accounts between 250000 and 300000. It includes a $limit stage to limit the output to 5 results and a $project stage to exclude all fields except accounts and name.

1
db.customers.aggregate([
2
  {
3
    "$search": {
4
      "range": {
5
        "path": "accounts",
6
        "gt": 250000,
7
        "lt": 400000
8
      }
9
    }
10
  },
11
  {
12
    "$limit": 5
13
  },
14
  {
15
    "$project": {
16
      "_id": 0,
17
      "accounts": 1,
18
      "name": 1
19
    }
20
  }
21
])

1
[
2
  {
3
    name: 'Elizabeth Ray',
4
    accounts: [ 371138, 324287, 276528, 332179, 422649, 387979 ]
5
  },
6
  {
7
    name: 'Katherine David',
8
    accounts: [ 462501, 228290, 968786, 515844, 377292 ]
9
  },
10
  {
11
    name: 'Brad Cardenas',
12
    accounts: [ 721914, 817222, 973067, 260799, 87389 ]
13
  },
14
  {
15
    name: 'Gary Nichols',
16
    accounts: [ 385397, 337979, 325377, 440243, 586395, 86702 ]
17
  },
18
  { name: 'Jennifer Lawrence', accounts: [ 344885, 839927, 853542 ] }
19
]