Article - CS51689
Understanding Database tables relationships to generate Queries or build Reports in Windchill PDMLink
Modified: 29-May-2025
Applies To
- Windchill PDMLink 6.2 to 11.1
Description
- Knowing how Windchill stores data at the database level can be useful for several reasons
- Creating SQL for reporting or as a building block to create Report Templates
- Getting master information from an iteration's ida2a2 value
- Look-up object information from a URL
- Finding primary key
- Understanding the Database table relationship to create the query builder report for all access imposed on the participant
- Query Builder Report to obtain a list of all database table in Windchill and relationships between them
This is a printer-friendly version of Article 51689 and may be out of date. For the latest version click CS51689