AnsweredAssumed Answered

Queying SQL Database For Return All Parts In A Vault

Question asked by Rafael Tangari on Aug 28, 2018
Latest reply on Sep 4, 2020 by Sameer Kelkar

Dear all friends,


Firstly, thanks for the attention! I would like to query my Enterprise PDM database and return a table with all the parts that I have inside a specific vault in my server.


Also, I would like to include in this query only the latest versions of the parts. With the columns, I want to include four metadata (Number, Description, Specification and Material).


After that, I would like to query for list only the assemblies in my vault.


I will use this report to populate our internal ERP/MRP system.


Thanks a lot for the help!