Skip to main content
A
Anonymous
April 26, 2016
Question

Windchill Relationtionship Report SQL SELECT

  • April 26, 2016
  • 1 reply
  • 4223 views

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 Version

Example output would be something like this:

ProE Versioned Part,12345.PRT,A.1,Associated Drawing,ProE Versioned Drawing,12345.DRW,B.5

I am slightly familiar with the tables epmdocumentmaster and epmdocument.
But I don't know which table (and fields) contains the relationship (where-used) data.

Any suggestions?

Windchill 9.1

Gerry Champoux

Williams International

Walled Lake, MI

1 reply

B
BineshKumar11-Visitor
1-Visitor
April 26, 2016

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

A
Anonymous
April 27, 2016

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

B
BineshKumar11-Visitor
1-Visitor
April 27, 2016

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

Terms & ConditionsCookie settingsAccessibility statement