I was wondering if anybody could help me get a BAQ setup that would allow me to export the standard routing for a specific part and all its assemblies with their operations. I currently have a BAQ that will pull BOM and Routing from a specific job but it duplicates the operations for each material and I am struggling to get it to only show the operations once.
If you want a part then that is PartOpr and PartMtl. Job would be JobOper and JobMtl.
You need a main query on PartRev or JobPart depending on which you want and then two sub queries for operations and materials. Depending on how big you data is you can either let the subs run then join them to the top or use a parameter that limits the data and use it on the main and both subs.
There are likely examples or already built baqs here.
1 Like