Skip to main content
M
MartinFalk-Schu1-Visitor
1-Visitor
April 28, 2009
Question

Report all WTParts related to WTDocuments

  • April 28, 2009
  • 1 reply
  • 3475 views

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

1 reply

M
mdebower18-Opal
18-Opal
March 25, 2016

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.

    B
    BineshKumar11-Visitor
    1-Visitor
    March 27, 2016

    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

      M
      mdebower18-Opal
      18-Opal
      March 28, 2016

      Thanks Binesh!   That put me on the right track.

      Here are the From statements I ended up with:

      20160328-141638.png

      ...and here is the join.

      20160328-141845.png

      Oh, and I still haven't gotten an answer from PTC TS yet.

      Terms & ConditionsAccessibility statement