This is similar to this question but my tree structure is not within a single document. Each children of a node tree is referred by its ID instead of being explicitly described in its parent. Here is an example: { "_id": "ROOT", "name": "root", "options": [ "NODE_1", "NODE_2", "NODE_3", …

Recursive look within a tree structure

vsr1 December 5, 2018, 1:04pm 2

N1QL Doesn’t support CONNECT BY.
You can check out this post and see if helps in what you are looking for N1QL - array join

Topic		Replies	Views
How to get a node of nested arrays without knowing the deep SQL++	2	1206	August 29, 2017
Finding sub documents recursively within a tree structure SQL++	3	1841	June 14, 2018
Query recursively nested structure SQL++	2	1147	March 5, 2020
How to get tree of documents in couchbase. Bottom up approach? SQL++ query	3	608	March 24, 2021
Possible to query for hierarchical data across documents? SQL++	7	3105	May 23, 2018