topic Windchill Relationtionship Report SQL SELECT in Windchill

Windchill Relationtionship Report SQL SELECT

gchampoux — Wed, 02 May 2018 11:46:00 GMT

I would like to produce a Windchill relationship text-file report for all Pro/E CAD Documents (epmdocument), using an SQL SELECT statement (Oracle).The output would include the following info:DOCTYPE, NUMBER, Version, relationship-type, Related-DOCTYPE, Related-NUMBER, Related VersionExample

Re: Windchill Relationtionship Report SQL SELECT

BineshKumar1 — Tue, 26 Apr 2016 15:16:45 GMT

For ASM to Part , use EPMMemberLink

select DISTINCT epm.cadname as "parent",epml.asstoredchildname as "child" from EPMMemberLink epml, epmdocumentmaster epm, epmdocument epmd

where epml.ida3a5=epmd.ida2a2 and epmd.ida3masterreference=epm.ida2a2 order by epm.cadname;

For Part,ASM to Drawing, use EPMReferenceLink

select DISTINCT epm.cadname as "parent",epml.asstoredchildname as "child" from EPMMemberLink epml, epmdocumentmaster epm, epmdocument epmd

where epml.ida3a5=epmd.ida2a2 and epmd.ida3masterreference=epm.ida2a2 order by epm.cadname;

Regards

Binesh Kumar

Medtronic MITG

Re: Windchill Relationtionship Report SQL SELECT

gchampoux — Wed, 27 Apr 2016 17:52:11 GMT

Binesh,

Thank you!

Before I try these, I need a clarification:

Both select statements appear to be identical.
In the second select statement, you said that I should use EPMReferenceLink.
Is that all I need to change? Is that the only difference needed?

Gerry

Re: Windchill Relationtionship Report SQL SELECT

BineshKumar1 — Wed, 27 Apr 2016 18:24:55 GMT

My bad, Gerry. I am sorry. I thought I changed it before I pasted it. In the second query just change the table to EPMReferenceLink/.

The relationship remains the same.

Regards

Binesh

Re: Windchill Relationtionship Report SQL SELECT

gchampoux — Wed, 27 Apr 2016 18:38:51 GMT

Binesh,

Thanks again.

How do I include the version (revision.iteration) info in the output for both epmdocuments?

Gerry

Re: Windchill Relationtionship Report SQL SELECT

BineshKumar1 — Wed, 27 Apr 2016 20:18:07 GMT

Hello Gerry,

epmd.VERSIONIDA2VERSIONINFO||'.'||epmd.ITERATIONIDA2ITERATIONINFO is where you can get the revision.iteration. They are stored in epmdocument table

Thank you

Binesh Kumar

Re: Windchill Relationtionship Report SQL SELECT

bclark-2 — Wed, 04 Apr 2018 21:32:02 GMT

Hello,

I am trying to the exact same thing as OP, but it seems that something is missing in the solution here. EPMReferenceLink gives you the link between the EPMDocument (Drawing) and the EPMDocumentMaster (Part), which means that you can find which exact version and iteration of the Drawing relates to a part, but not the exact version and iteration of that part.

Am I missing something here?