AnsweredAssumed Answered

Queying SQL Database For Return All Parts In A Vault

Question asked by Rafael Tangari on Aug 28, 2018
Latest reply on Aug 31, 2018 by Rafael Tangari

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!

 

Rafael.

Outcomes