Possible to query for hierarchical data across documents?

[vsr1]

Currently N1QL doesn’t support CONNECT BY

Based on your out put it is not possible. Check this post if u can build something similar

N1QL - array join

Hi, let’s say I have these documents: D0 { "items" = ["S0", "S1"] } D1 { "items" = ["S1", "S2", "S3", "S4"] } D2 { "items" = ["S4", "S5", "S6", "S7", "S8"] } D3 { "alias" = "A1", "items" = ["S7", "S8", "S9", "S10"] } D4 { "alias" = "A2", "items" = ["S11", "S12", "S13"] } D5 { "items" = ["S10", "S20", "S30"] } I need to find the union of all items by alias or by one item from items array. Example 1: find by S8 S8 -> D2 union D3 union D1 (S4 is reference) …