cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Get EPMDocument connected with WTPart via JSP

ptc-5476001
1-Visitor

Get EPMDocument connected with WTPart via JSP

Hi everybody!

1. how i can get (all) EPMDocument(s) connected with WTPart using JSP? what kind of link describes this connect?

thx!

1 REPLY 1

Hi Michael,

I think you are talking about an association link. Here are some queries for the connections:

  • WTPart, EPMDocuments having an association link:

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;

  • EPMDocuments not associated to WTParts:

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

Announcements


Top Tags