How can I project a nested object in lookupIn and n1ql ? I the following document { "foo":{ "bar":{ "a":1, "b":2, "c":3 }, "baz":{ "a":4, "b":5 } } } How we can select foo.*.a ? { "foo":{ "bar":{ "a":1 }, "baz":{ "a":4 …

Collection projection

vsr1 December 3, 2018, 1:31pm 2

You can’t use * in the middle. you need to provide explicit name or Use * at the end

Topic		Replies	Views
N1Ql select * adds bucket name to result set SQL++ query , n1ql	3	2625	August 14, 2017
Access to nested documents by property value SQL++	6	2104	December 16, 2016
How to query documents which are arrays SQL++ n1ql	1	870	March 7, 2018
Select only certain values from an array of objects SQL++ query , n1ql	2	3626	August 29, 2017
How to query one field in a document? SQL++ client , query , n1ql , server	1	2148	December 13, 2018