Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.
Hello,
I want to run a report which shows all teh WTParts related to a list of WTDocuments. I tried the WTPart described Link and also the Iterated describe Link without success. We use Reference Documents.
Any suggestions?
Regards
Martin
I have this same issue, and seeing how this hasn't been answered since 2009, I asked PTC TS. I will reply back to this message when I get an answer from them.
For described by document use wtpartdescibelink
SELECT docm.name as Doc_Name,
docm.WTDocumentNumber,
partm.name as Part_Name,
partm.WTPartNumber
FROM wc11.WTDocument doc ,
wc11.WTDocumentMaster docm,
wc11.WTPart part,
wc11.WTPartMaster partm,
wc11.WTPartDescribeLink pdl
WHERE (doc.idA3masterReference=docm.idA2A2) AND
(part.idA3masterReference=partm.idA2A2) AND
((pdl.idA3A5 = part.idA2A2) AND
(pdl.idA3B5 = doc.idA2A2));
For reference document use part describelink against doc master
SELECT docm.name as Doc_Name,
docm.WTDocumentNumber,
partm.name as Part_Name,
partm.WTPartNumber
FROM wc11.WTDocument doc ,
wc11.WTDocumentMaster docm,
wc11.WTPart part,
wc11.WTPartMaster partm,
WC11.wtpartreferencelink prl
WHERE (doc.idA3masterReference=docm.idA2A2) AND
(part.idA3masterReference=partm.idA2A2) AND
((prl.idA3A5 = part.idA2A2) AND
(prl.idA3B5 = docm.idA2A2));
Thank you
Binesh Kumar
Medtronic - MITG
Thanks Binesh! That put me on the right track.
Here are the From statements I ended up with:
...and here is the join.
Oh, and I still haven't gotten an answer from PTC TS yet.
Finally heard back from PTC TS. They pointed me to this article.
https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007