mongodb聚合获取数组中负序的最大数量

我需要通过聚合从数组中获取负序列的最大计数，示例文档：

  {
  "id": 1,
   x: [ 1,1,-1,-1,1,1,1,-1,-1,-1,-1]
 },
 {
"id": 2,
  x: [ 1,-1,-1,1,1,1,-1 ]
 }

预期结果：

 {"id": 1,x:4},
 {"id": 2,x:2}

请指教？

您可以使用$reduce https://docs.mongodb.com/manual/reference/operator/aggregation/reduce/迭代数组并$cond https://docs.mongodb.com/manual/reference/operator/aggregation/cond/应用你的逻辑（连续否定）

载体格式正确

     {
        previous: // previous value to compare for continuity 
        acc: // number of consecutive negatives in the current sequence
        max: // length of the longest sequence
      }

$let https://docs.mongodb.com/manual/reference/operator/aggregation/let/是记住当前累加器以在最大值计算中重用。它是可选的但很方便：

db.collection.aggregate([
  {
    "$set": {
      "x": {
        "$reduce": {
          "input": "$x",
          "initialValue": {
            previous: 0,
            acc: 0,
            max: 0
          },
          "in": {
            $let: {
              vars: {
                result: {
                  "$cond": {
                    "if": {
                      "$and": [
                        {
                          "$lt": [
                            "$$this",
                            0
                          ]
                        },
                        {
                          "$lt": [
                            "$$value.previous",
                            0
                          ]
                        }
                      ]
                    },
                    "then": {
                      "$add": [
                        "$$value.acc",
                        1
                      ]
                    },
                    "else": {
                      "$cond": {
                        "if": {
                          "$lt": [
                            "$$this",
                            0
                          ]
                        },
                        "then": 1,
                        "else": 0
                      }
                    }
                  }
                }
              },
              in: {
                previous: "$$this",
                acc: "$$result",
                max: {
                  "$cond": {
                    "if": {
                      $gt: [
                        "$$value.max",
                        "$$result"
                      ]
                    },
                    "then": "$$value.max",
                    "else": "$$result"
                  }
                }
              }
            }
          }
        }
      }
    }
  },
  {
    "$set": {
      x: "$x.max"
    }
  }
])

试试mongoplayground.net https://mongoplayground.net/p/LP0e3ppgOtt.