Where in database is wtPart attribute Type "partTypeName" ?

[HJ1]

Hi,

is it possible to retrieve the subtypes of wtPart from database? I was thinking the attribute partTypeName, but in which table is it? Or is it...

[rhart]

Hi @HJ1 ,

There's separate tables for the type and type master.

WTTypeDefinition

WTTypeDefinitionMaster

[HJ1]

Hi,

the requirement is to rule out in a db query wtParts which are of particular subtype...

so it's [idA2typeDefinitionReference] value in table WTPart, map that to WTTypeDefinition - idA2A2 and so on?

Enough of this for a Friday afternoon   😛

[HJ1]

Replying to myself on another Friday afternoon,

back-tracking from a wtPart which number is known, use the wtPart number to query 

WTPartMaster : WTPartNumber

then mapping goes

wtPartMaster : ida2a2 - wtPart: idA3masterReference
wtPart: branchIdA2typeDefinitionRefe - WTTypeDefinition: branchIditerationInfo

already the field

WTTypeDefinition : logicalIdentifier or name

seems to tell the type of the wtPart, but further:

WTTypeDefinition: idA3masterReference - WTTypeDefinitionMaster: ida2a2