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?
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.
Ok, where is Programmability -> Stored Procedures at?
Ah it's under the vault database in SQL Server Management Studio.
Thanks, found it.
I am looking for something like this. Did you manage do build a query for this?
Retrieving data ...