Skip to main content
3-Newcomer
Nov 2, 2026 5:39 AM UTC
Question

Custom WTPart Team Roles/Members SQL Query

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.0 In Windchill PDMLink, we created a custom part whose type inherits from WTPart. We now need to query, by custom part number, all roles and members of that part’s own team (not the product container/org-level team), including role name, user ID, login name, and full name. Please provide the complete table join/query path from WTPart → Team → Role → WTUser, and if possible an Oracle SQL example. Thank you!

1 reply

MarcoTosin
21-Topaz II
Nov 2, 2026 8:41 AM UTC

On the PTC community website and the support website, there are dozens of ready-to-use reports.

 

Based on the questions you’ve asked, it seems you’re just getting started with reports, so I recommend you start here.

https://www.ptc.com/en/support/wnc-reporting-landing

 

And then check out this HUB page, where the reports are organized into related categories:

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

 

Translate
Marco