带有可变键的Couchbase N1QL嵌套json查询

Question

我有文件。如何使用嵌套json字段编写查询？ query ：Count值大于3输出：doc-1和doc-3。

博士-1

"1": {
    "count":4,
    "name": "pen"
}

博士-2

"2": {
    "count":1,
    "name": "eraser"
}

博士-3

"3": {
    "count":43,
    "name": "book"
}

Answer 1

将动态对象(OBJECT_VALUES()、OBJECT_NAMES()、OBJECT_PAIRS())转换为数组并使用https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/objectfun.html子句

SELECT b.*
FROM mybucket AS b
WHERE ANY v IN OBJECT_VALUES(b) SATISFIES v.`count` > 3 END;