How to get Gathering Part information from DB table with query sql

[scaponio]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.19

How to get Gathering Part information from DB table with query sql

[joe_morton]

hi,

I'm not sure the specifics of querying SQL, but I can tell you that the Gathering Part attribute is on the Part Master, so you'll need to use that as a criteria in the query you build.

[Fadel]

SELECT  hidePartInStructure, WTPartNumber, name FROM  WTPartMaster ;