Hi, I am confused with all the possible options (NEST, JOIN, ARRAY_AGG) offered by N1QL. Should be a very common use case but now I cannot figure out which way to go. I could only do one level of nesting using NEST and ON KEY Thank you for your help. Here is my data, all in one bucket: {'type'…

INSERT INTO default VALUES ('company_A_id',{'type':'company', 'name':'company A'}); INSERT INTO default VALUES ('department_1_id',{'type':'department', 'name':'department 1', 'company_id':'company_A_id'}); INSERT INTO default VALUES ('department_2_id',{'type':'department', 'name':'department 2', 'co…

How to write Nest of Nest query

SQL++

vsr1 January 14, 2019, 4:32am 7

@function1983, The following resources will help you with N1QL . cc @keshav_m

Topic		Replies	Views
Nest queried documents SQL++	7	3044	April 11, 2017
Couchbase join & nest Couchbase Server n1ql	2	347	July 10, 2023
Multi-Level NEST Statements SQL++	3	2407	September 28, 2016
NEST on double nested array SQL++	2	785	August 31, 2020
N1QL query with second level nesting SQL++	15	7089	June 23, 2016

How to write Nest of Nest query

Related topics