I’m working on helping a user out with doing some NEST statements via LINQ, issue here:
In simple terms, they have a 3-tier document hierarchy, and want to use a single query to nest documents from the 3rd tier into the 2nd tier, which are then nested in the 1st tier.
In trying to figure out how to make the LINQ statement work, I started with trying to make the N1QL statement work. So far, I’ve been unable to find a route to perform multiple NEST statements where the second statement is nesting within the documents returned by the first NEST statement. I can only perform more NEST statements into the root document.
I have been able to emulate the behavior using sub-queries. However, I’m not sure of the performance impact compared to NEST statements. Also, NEST statements are much cleaner if that’s an option.
I just wanted to check and make sure I’m not missing something here.