facet （MongoDB Search 演算子）

1
db.movies.aggregate([
2
  {
3
    "$searchMeta": {
4
      "facet": {
5
        "operator": {
6
          "range": {
7
            "path": "released",
8
            "gte": ISODate("2000-01-01T00:00:00.000Z"),
9
            "lte": ISODate("2015-01-31T00:00:00.000Z")
10
          }
11
        },
12
        "facets": {
13
          "directorsFacet": {
14
            "type": "string",
15
            "path": "directors",
16
            "numBuckets" : 7
17
          },
18
          "yearFacet" : {
19
            "type" : "number",
20
            "path" : "year",
21
            "boundaries" : [2000,2005,2010, 2015]
22
          }
23
        }
24
      }
25
    }
26
  }
27
])

1
db.movies.aggregate([
2
 {
3
   "$search": {
4
     "facet": {
5
       "operator": {
6
         "near": {
7
           "path": "released",
8
           "origin": ISODate("1999-07-01T00:00:00.000+00:00"),
9
           "pivot": 7776000000
10
         }
11
       },
12
       "facets": {
13
         "genresFacet": {
14
           "type": "string",
15
           "path": "genres"
16
         }
17
       }
18
     }
19
   }
20
 },
21
 { "$limit": 2 },
22
 {
23
   "$facet": {
24
     "docs": [
25
       { "$project":
26
         {
27
           "title": 1,
28
           "released": 1
29
         }
30
       }
31
     ],
32
     "meta": [
33
       {"$replaceWith": "$$SEARCH_META"},
34
       {"$limit": 1}
35
     ]
36
   }
37
 },
38
 {
39
   "$set": {
40
     "meta": {
41
       "$arrayElemAt": ["$meta", 0]
42
     }
43
   }
44
 }
45
])

1
db.companies.aggregate([
2
 {
3
   "$searchMeta": {
4
     "returnStoredSource": true,
5
     "returnScope": {
6
       "path": "funding_rounds"
7
     },
8
     "facet": {
9
       "operator": {
10
         "text": {
11
           "path": "funding_rounds.raised_currency_code",
12
           "query": "USD"
13
         }
14
       },
15
       "facets": {
16
         "raisedAmountFacet": {
17
           "type": "number",
18
           "path": "funding_rounds.raised_amount",
19
           "boundaries": [5000000, 5250000, 5500000]
20
         }
21
       }
22
     }
23
   }
24
 }
25
])

1
db.listingsAndReviews.aggregate([
2
  {
3
    $searchMeta: {
4
      facet: {
5
        facets: {
6
          accommodatesFacet: {
7
            path: "accommodates",
8
            type: "number",
9
            boundaries: [1,2,4,8],
10
          },
11
          cancellationFacet: {
12
            path: "cancellation_policy",
13
            type: "string",
14
          },
15
          roomTypeFacet: {
16
            path: "room_type",
17
            type: "string",
18
          }
19
        },
20
        operator: {
21
          compound: {
22
            must: [
23
              {
24
                text: {
25
                  path: "description",
26
                  query: "new york city",
27
                },
28
              },
29
            ],
30
            filter: [
31
              {
32
                equals: {
33
                  path: "cancellation_policy",
34
                  value: "moderate",
35
                  doesNotAffect:
36
                    "cancellationFacet",
37
                },
38
              },
39
            ],
40
          },
41
        },
42
      },
43
    }
44
  },
45
]

1
db.listingsAndReviews.aggregate([
2
  {
3
    $searchMeta: {
4
      facet: {
5
        facets: {
6
          accommodatesFacet: {
7
            path: "accommodates",
8
            type: "number",
9
            boundaries: [1,2,4,8],
10
          },
11
          cancellationFacet: {
12
            path: "cancellation_policy",
13
            type: "string",
14
          },
15
          roomTypeFacet: {
16
            path: "room_type",
17
            type: "string",
18
          }
19
        },
20
        operator: {
21
          compound: {
22
            must: [
23
              {
24
                text: {
25
                  path: "description",
26
                  query: "new york city",
27
                },
28
              },
29
            ],
30
            filter: [
31
              {
32
                equals: {
33
                  path: "cancellation_policy",
34
                  value: "moderate",
35
                  doesNotAffect:
36
                    "accommodatesFacet",
37
                },
38
              },
39
            ],
40
          },
41
        },
42
      },
43
    },
44
  },
45
]