cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Schema tables oracle PDMLink 9

NinoDiPietranto
2-Guest
2-Guest
‎Sep 22, 2010 03:31 AM
‎Sep 22, 2010 03:31 AM

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.

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
FeofilovIvan
1-Newbie
1-Newbie
(To:NinoDiPietranto)
‎Sep 27, 2010 03:41 AM
‎Sep 27, 2010 03:41 AM

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.

0 Kudos
Notify Moderator
Top Tags