Recursion design question

[MichelDiz]

@ayorosmage

“one level predicate recurse limitation”.

That’s not a limitation. It’s a rule. You can retrieve anything from a recursive query.

@ayorosmage

Thus, I find this solution quite cumbersome. That’s why I’m asking if I’m doing something wrong and if there is an easiest alternative ?

Okay, I’ll work on a sample based on what you wrote and come up with something.