I’m trying to build a CTE BAQ that produces a BOM from PartMtl.
I want to filter the output of that BOM to only the Parts and Part Materials associated with the jobs from a specific Project.
ok, so go to the help file, and find the example to make a BOM CTE and build that, just like it shows. Once you have that working, then you can modify the anchor (the parameter that you put in) to be a project. Bring in the Job Head table, and set the parameter to filter the job head based on the project ID. Then link the job head part number to the partMtl table and it will filter the way you want.
