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 …

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

I know, but how can I select it??( project a field) [image] socketman2016: { “foo”:{ “bar”:{ “a”:1 }, “baz”:{ “a”:4 } } } I have a map of objects , my objects has large parts, I just need to select some fields

You need to construct Object according to requirements. insert into default values("1",{ "bar":{ "a":1, "b":2, "c":3 }, "baz":{ "a":4, "b":5 } }); SELECT OBJECT v.name: {v.val.a} FOR v IN OBJECT_PAIRS(d) END AS obj FROM default d;

What about bucket.lookupIn.get?

I am not expert in that area cc @ingenthr . Most probably you need to get whole document and select in SDKs or use subdoc API to get specific paths.

@vsr1 I found that foo[*].a works for arrays, but I don’t found for objects Where is foo[*].a document? I found it by try and fail

The Sub-Document API cannot do this iteration and processing. I believe it may be possible to do this with JSONPath. You can probably also build an index inclusive of projection in this case with Couchbase Views in javascript.

Collection projection

Java SDK

vsr1 December 3, 2018, 5:44pm 8

If array you can use foo[*].a because it subscripts, not for objects which needs fields.

https://docs.couchbase.com/server/6.0/n1ql/n1ql-language-reference/arrayfun.html#fn-array-star

Topic		Replies	Views
N1Ql select * adds bucket name to result set SQL++ query , n1ql	3	2673	August 14, 2017
Use Sub document API LookupIN to map multile fields to pojo using reflection Java SDK java	2	996	March 3, 2021
Select object nested in array Couchbase Server query	2	663	October 22, 2022
Nested document - Query Data Couchbase Server query , n1ql	2	846	July 29, 2020
How to query one field in a document? SQL++ client , query , n1ql , server	1	2177	December 13, 2018

Collection projection

Related topics