Report all WTParts related to WTDocuments

[MartinFalk-Schu]

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

[mdebower]

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.

[BineshKumar1]

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

[mdebower]

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.

[mdebower]

Finally heard back from PTC TS.  They pointed me to this article.

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS36007