Is there a SQL query that can do what the BOM tab does? I assume there is a SQL query in the background to find the bom data. Any examples out there?
Is there a SQL query that can do what the BOM tab does? I assume there is a SQL query in the background to find the bom data. Any examples out there?
Hey Mike,
If you check under Programability->Stored Procedures you'll see a BomListProcX where x is the BOMID for each BOM in that vault. That's a bit complicated to use for a report, but that's what's generating the info. If you're just trying to get at reference info you'll need to use a recursive common table expression on the xrefs table and slap a couple of variablevalue's on for the columns.