想要使用 N1QL Couchbase 将内部元素与 JSON 求和

当我运行下面的查询时

SELECT * FROM myBucket WHERE ANY x IN transactions SATISFIES x.type in [0,4] END;

Result:

{
  "_type": "Company",
  "created": "2015-12-01T18:30:00.000Z",
  "transactions": [
    {
      "amount": "96.5",
      "date": "2016-01-03T18:30:00.000Z",
      "type": 0
    },
    {
      "amount": "483.7",
      "date": "2016-01-10T18:30:00.000Z",
      "type": 0
    }
  ]
}

我得到多个像这样的json

SELECT sum(transactions[*].amount) FROM Inheritx WHERE ANY x IN transactions SATISFIES x.type in [0,4] END;

结果： [ { “$1”：空 } ]

Now我想总结一下这一切。我该怎么做？

transactions[*].amount 这是返回数组，因此首先需要使用数组函数

ARRAY_SUM

而不是使用如下所示的总和。

SELECT sum(ARRAY_SUM(transactions[*].amount)) FROM Inheritx WHERE ANY x IN transactions SATISFIES x.type in [0,4] END;