I’m using the UD03 table to hold a relationship between Parent (upstream) and Child (downstream) jobs. [image] As seen here, with PHP, I can do any number of loops from any focused job in the chain, going both upstream and downstream, finding any and all linked jobs recursively. [image] [Proble…

You can make a CTE subquery to do recursion. Here’s an example with menus. [image] Production Report with Parent-Child Grouping ERP 10 You’ll use those parent/child fields in your union all join. There’s another common example with menu hierarchy that does something simil…

And another example (long thread) which sounds close to what you’re trying to do (I think) ~If you want to recursively traverse the BOM you may need a CTE query?~ - Kinetic 2021 - Epicor User Help Forum (epiusers.help)

Thank you! I’ll give it a whirl.

As others have said… CTE is the answer… basically, it will take a three query BAQ: Query 1: CTE query that selects the “anchor” record to start the cycle Query 2: UNION ALL query that gathers all the records… this query uses query 1 as the anchor and gathers each layer, and will continue to do thi…

Thank you for that breakdown, Tim. I appreciate your time!

Is Infinitely Dynamic Recursion Possible in BAQs?

Epicor ERP 10

Asz0ka (Adam Szoka) July 15, 2021, 4:34pm 2

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

Topic		Replies	Views
BAQ Repeat Row Epicor ERP 10 e10	5	768	December 14, 2018
Recursive CTE BAQ Epicor ERP 10 baq	10	7986	November 19, 2019
Using more than one UnionAll type in a single BAQ Kinetic ERP	14	77	July 20, 2026
BAQ Union/Union All - Help Needed Epicor ERP 10 baq	10	6103	January 14, 2021
CTE-based BAQ Report Epicor ERP 10 e10	9	3700	July 22, 2020

Is Infinitely Dynamic Recursion Possible in BAQs?

Related topics