Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X
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.
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.