Linking Windchill information from EPM-tables and WTPart-tables

[bschmidt-2]

Hi Guys,

currently I´m trying to understand the database schema behind Windchill PDMLink.

My aim is to get all parts of an assembly, with all the attached information.

Now I have looked over some tables and foudn the links beetween them. But now I´m stuck!

How can I link the information from the EPMDocument (EPMDocumentMaster, ...) with the WTPart (WTPartMaster, ...) tables?

WTPartMasterKey and EPMDocumentMasterKey both have the field WTKey, but the have different contents.

I´m using Windchill PDMLink 9.1.

Thanks in advance!

Ben

[Marco_Tosin · Accepted solution]

Hi Ben,

look at this document I wrote http://communities.ptc.com/docs/DOC-6348

It's very long, but in the Tips and tricks section you can find an answer.

[bschmidt-2]

Hi Marco,

thanks, that´s awesome!

Way more than I expected.