Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X
Hi everybody!
1. how i can get (all) EPMDocument(s) connected with WTPart using JSP? what kind of link describes this connect?
thx!
Hi Michael,
I think you are talking about an association link. Here are some queries for the connections:
SELECT pm.name WTPartName, pm.wtpartnumber, em.cadname EPMDocName, em.documentnumber EPMDocNumber
FROM WTPart p, WTPartMaster pm, EPMDocument e, EPMDocumentMaster em, EPMBuildhistory ebh
WHERE e.ida3masterreference=em.ida2a2 AND p.ida3masterreference=pm.ida2a2 AND ebh.ida3a5=e.ida2a2 AND ebh.ida3b5=p.ida2a2;
SELECT em.cadname, e.ida2a2
FROM EPMDocument e, EPMDocumentMaster em
WHERE e.ida2a2 NOT IN (SELECT ida3a5 FROM EPMBuildhistory) AND e.ida3MasterReference=em.ida2a2;
Not really sure what your specific use case is so it is difficult to understand what exactly would be the best way to achieve it.
Typically parts are associated via auto associate. Is there a reason this isn't working for you?
Thanks,
Jarrett