Hi all, we build planes and I have been tasked to create a query that mimics an indented BOM with levels but for a Job and all its assemblies, subassemblies and materials. So, each plane has several jobs that roll up to a master job. Has anyone done something like this? I’d like to run it within sql without using CTE.
I believe there is a good example doing an indented BPM in the BAQ designer application help screen. That should get you moving in the right direction.