Skip to main content
12-Amethyst
May 26, 2016 12:49 PM UTC
Solved

SQL link between 2D and WTPART

Naamloos.png

Hello,

Does somebody know what the link in SQL is between a 2D drawing and a WTPart? I can't find it.

I tried this:

select epmdocumentmaster.documentnumber, wtpartnumber

from epmbuildrule,wtpart,wtpartmaster,epmdocument,epmdocumentmaster where

epmdocument.branchiditerationinfo = epmbuildrule.branchida3a5 and

epmdocument.latestiterationinfo='1' and

epmdocumentmaster.ida3a6 = epmdocument.ida3masterreference and

wtpart.branchiditerationinfo = epmbuildrule.branchida3b5 and

wtpart.latestiterationinfo='1' and

wtpartmaster.ida2a2 = wtpart.ida3masterreference and

wtpartmaster.wtpartnumber='7033571';

With this I get an empty result, so something is wrong.

Thanks in advance

2-Explorer
May 26, 2016 4:07 PM UTC

Use EPMReferenceLink

3 replies

1-Visitor
May 26, 2016 1:53 PM UTC

If the relationship shows as calculated, there is no direct relationship between a wtpart and a drawing. You will have to link it through the model.

EPMDocument -EPMDocument1(drawing)

WTPart-EPMDocument

Thanks

Pardeep

Translate
12-Amethyst
May 26, 2016 2:15 PM UTC

So then what is the link between a 3d model and a 2D drawing?

This I also don't know.

Thanks again

Translate
2-Explorer
May 26, 2016 4:07 PM UTC

Use EPMReferenceLink

Translate