in Operator

The following query uses the in operator to search the birthdate field, which contains a single value, for customers who were born on given dates. The query uses the $project stage to:

• Omit the _id field in the results.

• Include only the name and birthdate fields in the results.

1
db.customers.aggregate([
2
  {
3
    "$search": {
4
      "in": {
5
        "path": "birthdate",
6
        "value": [ISODate("1977-03-02T02:20:31.000+00:00"), ISODate("1977-03-01T00:00:00.000+00:00"), ISODate("1977-05-06T21:57:35.000+00:00")]
7
      }
8
    }
9
  },
10
  {
11
    "$project": {
12
      "_id": 0,
13
      "name": 1,
14
      "birthdate": 1
15
    }
16
  }
17
])

1
[
2
  {
3
    name: 'Elizabeth Ray',
4
    birthdate: ISODate("1977-03-02T02:20:31.000Z")
5
  },
6
  {
7
    name: 'Brad Cardenas',
8
    birthdate: ISODate("1977-05-06T21:57:35.000Z")
9
  }
10
]

MongoDB Search returns two documents that it matches with the dates specified in the query.

The following query uses the in operator to query the accounts field, which contains an array of numbers, for customers with account numbers 371138, 371139, or 371140. The query uses the $project stage to:

• Omit the _id field in the results.

• Include only the name and accounts fields in the results.

1
db.customers.aggregate([
2
  {
3
    "$search": {
4
      "in": {
5
        "path": "accounts",
6
        "value": [371138, 371139, 371140]
7
      }
8
    }
9
  },
10
  {
11
    "$project": {
12
      "_id": 0,
13
      "name": 1,
14
      "accounts": 1
15
    }
16
  }
17
])

1
[
2
  {
3
    name: 'Elizabeth Ray',
4
    accounts: [ 371138, 324287, 276528, 332179, 422649, 387979 ]
5
  }
6
]

MongoDB Search returns only one document that it matches with the account number 371138 specified in the query.

The following query uses the text operator to query for customers whose first name is James in the name field. The query specifies preference using the in operator for customers associated with the given objectIds in the _id field. The query uses $limit stage to limit the output to 5 results and the $project stage to:

• Include only the _id and name fields in the results.

• Add a field named score to the results.

1
db.customers.aggregate([
2
  {
3
    "$search": {
4
      "compound": {
5
        "must": [{
6
          "in": {
7
            "path": "name",
8
            "value": ["james sanchez", "jennifer lawrence"]
9
          }
10
        }],
11
        "should": [{
12
          "in": {
13
            "path": "_id",
14
            "value": [ObjectId("5ca4bbcea2dd94ee58162a72"), ObjectId("5ca4bbcea2dd94ee58162a91")]
15
          }
16
        }]
17
      }
18
    }
19
  },
20
  {
21
    "$limit": 5
22
  },
23
  {
24
    "$project": {
25
      "_id": 1,
26
      "name": 1,
27
      "score": { $meta: "searchScore" }
28
    }
29
  }
30
])

1
[
2
  {
3
    _id: ObjectId("5ca4bbcea2dd94ee58162a72"),
4
    name: 'James Sanchez',
5
    score: 2
6
  },
7
  {
8
    _id: ObjectId("5ca4bbcea2dd94ee58162a71"),
9
    name: 'Jennifer Lawrence',
10
    score: 1
11
  }
12
]

MongoDB Search returns documents that contain James Sanchez and Jennifer Lawrence in the name field. MongoDB Search scores the document that contains name: 'James Sanchez' higher because it matches the ObjectId specified in the should clause.