My docs like this: {"_id":"list1","type":"list","members":["member1","member2","member3"],"name":"list_name1"} I want query data by id to get the follows result: [ { "name": "list_name1", "member":"member1" }, { "name": "list_name1", "member":"member2" }, { "name": "…

here you go; select a.name, b as member from your_bucket a unnest a.members b;

How to select value of array as multi result?

atom_yang February 12, 2016, 4:59am 3

Thank you very much, It works.

Topic		Replies	Views
Query to retrieve and flatten array in results SQL++ n1ql	9	1753	May 13, 2021
Create new array from nesting docs SQL++ query , n1ql	13	2098	September 24, 2016
Multiple UNNEST on N1QL having multiple joins SQL++ query , n1ql	9	3298	May 2, 2022
Concatenating lists from several documents SQL++	10	1739	April 3, 2017
Get data from nested object SQL++ query , n1ql	2	1347	January 10, 2022