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.