自定义结果中文档的分数

1
db.movies.aggregate([{
2
    "$search": {
3
      "text": {
4
        "query": "Helsinki",
5
        "path": "plot"
6
      }
7
    }
8
  },
9
  {
10
    "$limit": 5
11
  },
12
  {
13
    "$project": {
14
      "_id": 0,
15
      "title": 1,
16
      "score": 1,
17
      "maxScore": 1,
18
      "normalizedScore": 1
19
    }
20
  },
21
  {
22
    "$addFields": {
23
      "score": {
24
        "$meta": "searchScore"
25
      }
26
    }
27
  },
28
  {
29
    "$setWindowFields": {
30
      "output": {
31
        "maxScore": {
32
          "$max": "$score"
33
        }
34
      }
35
    }
36
  },
37
  {
38
    "$addFields": {
39
      "normalizedScore": {
40
        "$divide": [
41
          "$score", "$maxScore"
42
        ]
43
      }
44
    }
45
}])

1
db.movies.aggregate([{
2
    "$search": {
3
      "text": {
4
        "path": "title",
5
        "query": "men",
6
        "score": {
7
          "function":{
8
            "multiply":[
9
              {
10
                "path": {
11
                  "value": "imdb.rating",
12
                  "undefined": 2
13
                }
14
              },
15
              {
16
                "score": "relevance"
17
              }
18
            ]
19
          }
20
        }
21
      }
22
    }
23
  },
24
  {
25
    "$limit": 5
26
  },
27
  {
28
    "$addFields": {
29
      "score": {
30
        "$meta": "searchScore"
31
      }
32
    }
33
  },
34
  {
35
    "$setWindowFields": {
36
      "output": {
37
        "maxScore": {
38
          "$max": "$score"
39
        }
40
      }
41
    }
42
  },
43
  {
44
    "$addFields": {
45
      "normalizedScore": {
46
        "$divide": [
47
          "$score", "$maxScore"
48
        ]
49
      }
50
    }
51
  },
52
  {
53
    "$project": {
54
      "_id": 0,
55
      "title": 1,
56
      "score": 1,
57
      "maxScore": 1,
58
      "normalizedScore": 1
59
    }
60
}])

1
db.movies.aggregate([{
2
    "$search": {
3
      "text": {
4
        "path": "title",
5
        "query": "shop",
6
        "score": {
7
          "function":{
8
            "gauss": {
9
              "path": {
10
                "value": "imdb.rating",
11
                "undefined": 4.6
12
              },
13
              "origin": 9.5,
14
              "scale": 5,
15
              "offset": 0,
16
              "decay": 0.5
17
            }
18
          }
19
        }
20
      }
21
    }
22
  },
23
  {
24
    "$limit": 5
25
  },
26
  {
27
    "$addFields": {
28
      "score": {
29
        "$meta": "searchScore"
30
      }
31
    }
32
  },
33
  {
34
    "$setWindowFields": {
35
      "output": {
36
        "maxScore": {
37
          "$max": "$score"
38
        }
39
      }
40
    }
41
  },
42
  {
43
    "$addFields": {
44
      "normalizedScore": {
45
        "$divide": [
46
          "$score", "$maxScore"
47
        ]
48
      }
49
    }
50
  },
51
  {
52
    "$project": {
53
      "_id": 0,
54
      "title": 1,
55
      "score": 1,
56
      "maxScore": 1,
57
      "normalizedScore": 1
58
    }
59
}])

1
db.movies.aggregate([{
2
    "$search": {
3
      "text": {
4
        "path": "title",
5
        "query": "men",
6
        "score": {
7
          "function":{
8
            "path": {
9
              "value": "imdb.rating",
10
              "undefined": 4.6
11
            }
12
          }
13
        }
14
      }
15
    }
16
  },
17
  {
18
    "$limit": 5
19
  },
20
  {
21
    "$addFields": {
22
      "score": {
23
        "$meta": "searchScore"
24
      }
25
    }
26
  },
27
  {
28
    "$setWindowFields": {
29
      "output": {
30
        "maxScore": {
31
          "$max": "$score"
32
        }
33
      }
34
    }
35
  },
36
  {
37
    "$addFields": {
38
      "normalizedScore": {
39
        "$divide": [
40
          "$score", "$maxScore"
41
        ]
42
      }
43
    }
44
  },
45
  {
46
    "$project": {
47
      "_id": 0,
48
      "title": 1,
49
      "score": 1,
50
      "maxScore": 1,
51
      "normalizedScore": 1
52
    }
53
}])

1
db.movies.aggregate([{
2
    "$search": {
3
        "text": {
4
          "path": "title",
5
          "query": "men",
6
          "score": {
7
            "function": {
8
              "log": {
9
                "path": {
10
                "value": "imdb.rating",
11
                "undefined": 10
12
                }
13
              }
14
            }
15
          }
16
        }
17
      }
18
    },
19
    {
20
      "$limit": 5
21
    },
22
    {
23
      "$addFields": {
24
        "score": {
25
          "$meta": "searchScore"
26
        }
27
      }
28
    },
29
    {
30
      "$setWindowFields": {
31
        "output": {
32
          "maxScore": {
33
            "$max": "$score"
34
          }
35
        }
36
      }
37
    },
38
    {
39
      "$addFields": {
40
        "normalizedScore": {
41
          "$divide": [
42
              "$score", "$maxScore"
43
        ]
44
        }
45
      }
46
    },
47
    {
48
      "$project": {
49
        "_id": 0,
50
        "title": 1,
51
        "score": 1,
52
        "maxScore": 1,
53
        "normalizedScore": 1
54
      }
55
    }
56
])