Skip to main content
H
HJ115-Moonstone
15-Moonstone
June 3, 2021
Question

Where in database is wtPart attribute Type "partTypeName" ?

  • June 3, 2021
  • 1 reply
  • 2311 views

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...

1 reply

R
rhart16-Pearl
16-Pearl
June 4, 2021

Hi @HJ1 ,

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

WTTypeDefinition

WTTypeDefinitionMaster

    H
    HJ115-MoonstoneAuthor
    15-Moonstone
    June 4, 2021

    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   😛

    H
    HJ115-MoonstoneAuthor
    15-Moonstone
    August 6, 2021

    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

    Terms & ConditionsAccessibility statement