Skip to main content
LV_104420014-Participant
4-Participant
October 4, 2022
Solved

SQL Database

Can help to point to the file name which stores the database table for PDM

WhatsApp Image 2022-10-04 at 5.20.32 PM.jpeg

HelesicPetr
HelesicPetrAnswer
22-Sapphire II
October 7, 2022

@LV_10442001 

It is complicated. Each type of object has own table.

WTPart, EPMDocument, Product, Library, Folders.

 

There is not just one table that shows you content of specific product.

 

You need to observe the sql selects in  the articles and you may find the links between tables and other consequences.

 

for example 

WTPart table contains reference to a context and context is a product or a library

 

PS: select * from WindchillDB.PDMLinkProduct shows the product information

 

PetrH

View in thread

5 replies

HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
October 5, 2022

Hi @LV_10442001 

Do you need a file name of Windchill object or do you need the file name of Vault file ?

PetrH

Translate
HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
October 5, 2022

@LV_10442001 

PTC Knowladge articles describes how to find vault file name

 

cs276507

cs322648  

 

PetrH

Translate
LV_104420014-ParticipantAuthor
4-Participant
October 7, 2022

Hi HelesicPetr,

 

thanks for the reply. I am looking for a specific table on SQL server which stores the details for the each product created. Please refer image below.

LV_10442001_0-1665129612937.png

 

Translate
HelesicPetr
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
October 7, 2022

@LV_10442001 

It is complicated. Each type of object has own table.

WTPart, EPMDocument, Product, Library, Folders.

 

There is not just one table that shows you content of specific product.

 

You need to observe the sql selects in  the articles and you may find the links between tables and other consequences.

 

for example 

WTPart table contains reference to a context and context is a product or a library

 

PS: select * from WindchillDB.PDMLinkProduct shows the product information

 

PetrH

Translate
    Terms & ConditionsAccessibility statement