Is Infinitely Dynamic Recursion Possible in BAQs?

[Asz0ka (Adam Szoka)]

You can make a CTE subquery to do recursion. Here’s an example with menus.

Production Report with Parent-Child Grouping

You’ll use those parent/child fields in your union all join. There’s another common example with menu hierarchy that does something similar, might be a better example: cte_testing.baq (39.7 KB)