json Couchbase n1q1查询以获取map的特定键

z18hc3ub  于 2023-04-13  发布在  Hbase
关注(0)|答案(1)|浏览(137)

下面是沙发底座文档`

{
  "docId": "1111212",
  "user": {
    "id": "5050017",  
    "name": "string", 
    "type": "string"
  },
  "books": {
        "1": {
          "id": "1",
          "name": "Book1",
          "author":{
             "id":"A1",
             "name":"name"
          }
        }
      "2": {
          "id": "2",
          "name": "Book2",
          "author":{
             "id":"A2",
             "name":"name"
            }
        }
    }
}

'我需要使用选择查询获取所有书籍名称我尝试了此操作

SELECT b.books.*.name FROM bucket_name b   where meta().id like '%books_details%' OFFSET 0 LIMIT 10

我能够得到所有的json键下的书籍,但不是字段下的每个Map。
SELECT OBJECT_NAMES(b.books)FROM bucket_name b where meta().id like '%books_details%' OFFSET 0 LIMIT 10

qnzebej0

qnzebej01#

SELECT u.* 
FROM bucket_name AS b 
UNNEST OBJECT_VALUES(b.books) AS u
WHERE .....;

SELECT ARRAY v.name FOR f:v IN b.books END AS names
FROM bucket_name AS b;

相关问题