compound

must and mustNot Example

The following example uses a combination of must and mustNot clauses to contruct a query. The must clause uses the text operator to search for the term varieties in the description field. For a document to match, it must fulfill the must clause. The mustNot clause performs a search operation for the term apples in the description field. For a document to match, it must not fulfill the mustNot clause.

1
db.fruit.aggregate([
2
  {
3
    $search: {
4
      "compound": {
5
        "must": [{
6
          "text": {
7
            "query": "varieties",
8
            "path": "description"
9
          }
10
        }],
11
        "mustNot": [{
12
          "text": {
13
            "query": "apples",
14
            "path": "description"
15
          }
16
        }]
17
      }
18
    }
19
  }
20
])

The above query returns the document with _id: 3 because its description field contains the word varieties and does not contain apples.

must and should Example

The following queries use must to specify search conditions that must be met and should to specify preference for documents that contain the word Fuji.

minimumShouldMatch Example

In a query with multiple should clauses, you can use the miniumumShouldMatch option to specify a minimum number of clauses which must match to return a result.

The following query has one must clause and two should clauses, with a minimumShouldMatch value of 1. A document must include the term varieties in the description field and must include either Fuji or Golden Delicious in the description field to be included in the result set.

1
db.fruit.aggregate([
2
  {
3
    $search: {
4
      "compound": {
5
        "must": [{
6
          "text": {
7
             "query": "varieties",
8
             "path": "description"
9
          }
10
        }],
11
        "should": [
12
          {
13
            "text": {
14
              "query": "Fuji",
15
              "path": "description"
16
            }
17
          },
18
          {
19
            "text": {
20
              "query": "Golden Delicious",
21
              "path": "description"
22
            }
23
          }],
24
          "minimumShouldMatch": 1
25
        }
26
      }
27
    }
28
])

The above query returns the following result:

{
  "_id" : 1,
  "type" : "apple",
  "description" : "Apples come in several varieties, including Fuji, Granny Smith, and Honeycrisp.",
  "category" : "nonorganic",
  "in_stock" : false
}

The document with _id: 1 matches the must clause and the first of the two should clauses.

filter Examples

filter behaves the same as must, except that the filter clause is not considered in a returned document's score, and therefore does not affect the order of the returned documents.

Nested Example

The following example uses nested compound clauses to construct a query. For this example, the fruit collection has an index on the type, category, and in_stock fields, whose text fields use the default analyzer. The query requires documents to only satisfy one of the following should clauses:

• Contain the word apple in the type field.

• Contain the term organic in the category field and have the value true in the in_stock field.

1
db.fruit.aggregate([
2
  {
3
    $search: {
4
      "compound": {
5
        "should": [
6
          {
7
            "text": {
8
              "query": "apple",
9
              "path": "type"
10
            }
11
          },
12
          {
13
            "compound": {
14
              "must": [
15
                {
16
                  "text": {
17
                    "query": "organic",
18
                    "path": "category"
19
                  }
20
                },
21
                {
22
                  "equals": {
23
                    "value": true,
24
                    "path": "in_stock"
25
                  }
26
                }
27
              ]
28
            }
29
          }
30
        ],
31
        "minimumShouldMatch": 1
32
      }
33
    }
34
  }
35
])

The above query returns the following result:

{
  "_id" : 3,
  "type" : "pear",
  "description" : "Bosc and Bartlett are the most common varieties of pears.",
  "category" : "organic",
  "in_stock" : true
}
{
  "_id" : 1,
  "type" : "apple",
  "description" : "Apples come in several varieties, including Fuji, Granny Smith, and Honeycrisp.",
  "category" : "nonorganic",
  "in_stock" : false
}

The above document fulfills all the requirements for inclusion:

• The document with _id: 3 matches the must clause nested within the second should clause.

• The document with _id: 1 matches the first should clause.