5 Replies Latest reply on Mar 16, 2018 10:56 AM by Martin Solem

SQL Query for assembly BOM?

Mike Sveda May 18, 2015 2:12 PM

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?

Re: SQL Query for assembly BOM?

Charley Saint May 18, 2015 2:27 PM (in response to Mike Sveda)

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.
Like Show 1 Likes(1)

Actions
- Re: SQL Query for assembly BOM?
  
  Mike Sveda May 18, 2015 2:33 PM (in response to Charley Saint)
  
  Ok, where is Programmability -> Stored Procedures at?
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: SQL Query for assembly BOM?
    
    Charley Saint May 18, 2015 2:35 PM (in response to Mike Sveda)
    
    Hey Mike,
    
    Ah it's under the vault database in SQL Server Management Studio.
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: SQL Query for assembly BOM?
      
      Mike Sveda May 18, 2015 3:24 PM (in response to Charley Saint)
      
      Thanks, found it.
      
      Like Show 1 Likes(1)
      
      Actions
      - Re: SQL Query for assembly BOM?
        
        Martin Solem Mar 16, 2018 10:56 AM (in response to Mike Sveda)
        
        Hi Mike,
        
        I am looking for something like this. Did you manage do build a query for this?
        
        Like Show 2 Likes(2)
        
        Actions

Go to original post