Skip to main content
4-Participant
April 27, 2023
Question

how to query and get the relation for Part with AML/AVL by SQL in database

  • April 27, 2023
  • 1 reply
  • 946 views

I am using Windchill PDMLink Release 11.0 and Datecode with CPS M030-CPS22

 

Through database query (SQL). How to query the AML/AVL association of the material number

how to get the relation(link) of the specific part with manufacturer and manufacture part (AML/AVL) in database by SQL
Is the relation (AML/AVL) a table in database ?

 

Translated by the Community Moderation using Google Translate 
-----------------------------------------------------------------------------------------------
透過資料庫查詢(SQL)。如何查詢料號AML/AVL 關聯

1 reply

Marco Tosin
21-Topaz I
21-Topaz I
April 27, 2023

If you search the Technical Support Knowledge Base, you will find plenty of articles explaining how to run queries in the Windchill database.

 

For the SuMa module, there is a summary article

https://www.ptc.com/en/support/article/CS385132

 

As well as a specific one that might be right for you.

https://www.ptc.com/en/support/article/CS40399

 

From the query builder reports you can also extract the related SQL query.

https://www.ptc.com/it/support/article/CS135285

 

 

 

Marco