in Operador

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:

• Omita o campo _id nos resultados.

• Inclua apenas os campos name e birthdate nos resultados.

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
]

A pesquisa do MongoDB retorna dois documentos que correspondem às datas especificadas na 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:

• Omita o campo _id nos resultados.

• Inclua apenas os campos name e accounts nos resultados.

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
]

A Pesquisa do MongoDB retorna apenas um documento que corresponde ao número de conta 371138 especificado na 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:

• Inclua apenas os campos _id e name nos resultados.

• Adicione um campo denominado score aos resultados.

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
]

A Pesquisa do MongoDB retorna documentos que contêm James Sanchez e Jennifer Lawrence no campo name. O MongoDB Search pontua o documento que contém name: 'James Sanchez' mais alto porque corresponde ao ObjectId especificado na cláusula should.