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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Schema tables oracle PDMLink 9

NinoDiPietranto
10-Marble

Schema tables oracle PDMLink 9

Hi, in the past using INTRALINK 3.4 I managed to get the BOM, search the oracle db etc.. etc..

Today with PDMLink 9 I can search the db but with a very long time, I found the tables that are mainly the following:

GUEST_EPMDOCUMENT

GUEST_EPMDOCUMENTMASTER

GUEST_EPMDOCUMENTMASTERKEY

GUEST_EPMFEATUREDEFINITION

GUEST_EPMFEATUREVALUE

GUEST_STRINGVALUE

GUEST_EPMPARAMETERVALUE

The ultimate aim is to search through the db and user parameters then perform the assembly, all through sciluppato application in Visual Basic. Has anyone done something like that? What are the formats to be sure to separate out information on the latest iteration? Sql sample.

Thanks

Nino Di Pietrantonio

P.S.

Translation from Italian to English automatically, sorry.

1 REPLY 1

Please post value of "search time".

To see which sql query executed, you can create simple report with where in "Windchill Report Tool" and seen SQL code, click on SQL button in this applet.

Announcements


Top Tags