Hi I’m trying to make a recursive CTE but I’m not sure how to get the CTE to reference itself (the UNION ALL statement and the code underneath that references to first block). I’ve heard it’s possible to do in E10 but I can’t find any examples. Is it done differently in a BAQ? Any help would be g…

F1 (Help) in the baq screen has a very thorough example of how to do this and generate a multi level bom

Apologies I’ve looked through the help files but I can’t find an example that helps me with this problem. I’ve been looking through: Epicor ERP User Guides > Tools User Guide > Business Activity Queries section Am I looking in the right place?

It’s in the Epicor Help F1 (File -> Help)

Thanks! I’ve followed the instructions but I’m getting a syntax error with the indent columns, the help files say to add this code: cast ( substring(’…’,1 ,(Hierarchy + 1) ) + PartMtl.MtlPartNum as nvarchar(25)) But it says Incorrect syntax near ‘…’. Is the ‘…’ supposed to be an expression?

The ‘…’ creates the indented look, that is needed. Do you have the Hierarchy column created?

I do have the Hierarchy column created

Are the apostrophe’s the “straight” kind or the smart kind?

Would you be able to copy and paste the query phrase. That will help us see where the issue might be.

Recursive CTE BAQ

Epicor ERP 10

bordway (Bruce Ordway) November 18, 2019, 6:14pm 6

You could try the search word indented…
The list returned should include a few threads that discuss the indenting of BOMs which might get you started.
e.g. here is one link:

Topic		Replies	Views
BAQ Union/Union All - Help Needed Epicor ERP 10 baq	10	6048	January 14, 2021
Need an Indented BOM BAQ Epicor ERP 10 e10	16	5897	April 30, 2026
CTE-based BAQ Report Epicor ERP 10 e10	9	3690	July 22, 2020
Is Infinitely Dynamic Recursion Possible in BAQs? Epicor ERP 10 e10 , baq	5	1057	July 15, 2021
Indented BOM in a BAQ Epicor ERP 10 baq	3	2379	January 21, 2022

Recursive CTE BAQ

Related topics