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!

