Skip to main content
A
adev1-Visitor
1-Visitor
January 15, 2016
Solved

How to get CAD Structure

  • January 15, 2016
  • 1 reply
  • 4327 views

Hello friends,

I am looking for a query which can return me the CAD structure in windchill does some body know how we can achieve this. please see the screen shot

Best answer by BineshKumar1
SELECT DISTINCT A0B.name ParentName,


                A0B.documentNumber ParentNumber,


                A2B.name ChildName,


                A2B.documentNumber ChildNumber


FROM            EPMDocument A0,


                EPMDocumentMaster A0B,


                EPMDocumentMaster A1,


                EPMDocument A2,


                EPMDocumentMaster A2B,


                EPMMemberLink A3


WHERE           (A0.idA3masterReference=A0B.idA2A2)


AND             (A2.idA3masterReference=A2B.idA2A2)


AND              ((A0B.name = 'ER00020039.asm'))


AND             ((A3.idA3B5 = A1.idA2A2)


AND              (A3.idA3A5 = A0.idA2A2)


AND           (A2.idA3masterReference = A1.idA2A2));

Try this. It worked on my system to get level 1 CAD structure.

Thank you

Binesh Kumar

1 reply

B
BineshKumar11-Visitor
1-Visitor
January 15, 2016

User epmmemberlink table to connect two epmdocuments. If you are looking for reference documents, use epmreference table

Thank you,

Binesh

A
adev1-VisitorAuthor
1-Visitor
January 16, 2016

Hi Binesh,

I try this but seems like not getting the accurate result

SELECT    dM2.DOCUMENTNUMBER AS ASSEMBLY, M1.DOCUMENTNUMBER AS COMPONENT

FROM      EPMDOCUMENT, EPMDOCUMENTMASTER M2, EPMMEMBERLINK, EPMDOCUMENTMASTER M1

WHERE       EPMMEMBERLINK.IDA3B5 = M1.IDA2A2

                   and M2.DOCUMENTNUMBER = 'W10805805_CP01.PRT'

                   and EPMDOCUMENT.IDA3MASTERREFERENCE = M1.IDA2A2

GROUP BY  M2.DOCUMENTNUMBER, M1.DOCUMENTNUMBER

order by  M2.DOCUMENTNUMBER, M1.DOCUMENTNUMBER;

B
BineshKumar11-VisitorAnswer
1-Visitor
January 16, 2016
SELECT DISTINCT A0B.name ParentName,


                A0B.documentNumber ParentNumber,


                A2B.name ChildName,


                A2B.documentNumber ChildNumber


FROM            EPMDocument A0,


                EPMDocumentMaster A0B,


                EPMDocumentMaster A1,


                EPMDocument A2,


                EPMDocumentMaster A2B,


                EPMMemberLink A3


WHERE           (A0.idA3masterReference=A0B.idA2A2)


AND             (A2.idA3masterReference=A2B.idA2A2)


AND              ((A0B.name = 'ER00020039.asm'))


AND             ((A3.idA3B5 = A1.idA2A2)


AND              (A3.idA3A5 = A0.idA2A2)


AND           (A2.idA3masterReference = A1.idA2A2));

Try this. It worked on my system to get level 1 CAD structure.

Thank you

Binesh Kumar

Terms & ConditionsCookie settingsAccessibility statement