AnsweredAssumed Answered

How to access part/assembly files Data Cards using SQL

Question asked by Sameer Kelkar on Sep 4, 2020
Latest reply on Sep 8, 2020 by Sameer Kelkar

Hi,

 

I needed to extract BOM in excel format using SQL. I refereed Queying SQL Database For Return All Parts In A Vault  and it is super-useful. But it gives me only Parent and Child filenames in the output.

 

We use "Data-card" to populate meta information (e.g. Item Code) pertaining to each assembly and part file which is useful for our ERP. I need to augment above query to include Item code from the data card for each file in a separate column. 

 

I could not figure out how to access data card information per file. How to go about that? Any help is greatly appreciated.

 

Thanks

Sameer Kelkar

Outcomes