Finding the link between the family table instance and its epmdocumentmaster

[phartwig]

All,

[RajuPulavarthi]

Paul - EPMContainedIn table links EPMDocument and EPMSepFamilyTable as Role A and Role B objects respectively. So you have to join EPMDocument and EPMSepFamilyTable with EPMContainedIn along with joining EPMDocumentMaster with EPM Document and EPMSepFamilyTable Master with EPMSepFamilyTable .



Raju Pulavarthi
Sr. Systems Analyst - PLM Applications
Global Information Technology

[dgraham-4]

Paul,

Here's the SQL select statement. I assume you have the instances
EPMSepFamilyTableMaster ida2a2

select distinct(ida3MasterReference) from EPMDocument where ida2a2 IN
(select distinct(ida3a5) from EPMContainedIn where ida3b5 IN (select
ida2a2 from EPMSepFamilyTable where
IDA3MASTERREFERENCE=<epmsepfamilytablemaster ida2a2=">));

Hope this helps

David Graham
Windchill Developer/Administrator
CAx Administrator


Emhart Glass Manufacturing Inc.
Emhart Glass Research Center
123 Great Pond Drive | Windsor, CT 06095 | USA
Telephone +1 (203) 376-3144 | Telefax +1 (860) 298 7397
Mobile +1 (203) 376-3144 |

[ab7nov]

Hi

Can you please help me to extract vault file for family table.