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

How to get CAD Structure

SOLVED
Highlighted
Newbie

How to get CAD Structure

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to get CAD Structure

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

6 REPLIES 6

Re: How to get CAD Structure

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

Thank you,

Binesh

Re: How to get CAD Structure

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;

Re: How to get CAD Structure

Could you try this one?

EPMDocument A0,EPMDocumentMaster A1,EPMDocument A2,EPMDocumentMaster A3,PDMLinkProduct A4,EPMMemberLink A5

A0.idA3masterReference = A1.idA2A2

A2.idA3masterReference = A3.idA2A2

A5.idA3B5 = A1.idA2A2

A5.idA3A5 = A2.idA2A2

Thank you

Binesh Kumar

Re: How to get CAD Structure

nup it did not workout gives null values

Re: How to get CAD Structure

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

Re: How to get CAD Structure

It worked Thank ou so much Binesh