Skip to main content
P
PH_107698351-Visitor
1-Visitor
July 29, 2013
Question

Finding the link between the family table instance and its epmdocumentmaster

  • July 29, 2013
  • 2 replies
  • 2234 views

All,



2 replies

R
RajuPulavarthi1-Visitor
1-Visitor
July 29, 2013
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
D
dgraham-41-Visitor
1-Visitor
July 30, 2013
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 |
A
ab7nov5-Regular Member
5-Regular Member
December 14, 2018

Hi

 

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

Terms & ConditionsAccessibility statement