Skip to main content
phsimard6-Contributor
6-Contributor
November 23, 2023
Solved

FIND NAME of WTDocument SubType in SQL Windchill

I am using Windchill PDMLink Release 11.1 and Datecode with CPS M020-CPS23

I cannot find the table that holds the SUB object types in Oracle SQL

Example: WTDocument:

I believe WTDocument.BRANCHIDA2TYPEDEFINTIONREFERENCE and
WTDOCUEMENT.IDA2TYPEDEFINITION REFERENCE hold the ID of the SUB TYPE of WTDocument.

However, I cannot find the table with which to join to get the UI NAME for those ID's.
    Fadel
    FadelAnswer
    23-Emerald II
    November 24, 2023

    try something  like below 

    select wtm.name,wtm.wtpartnumber,wtd.logicalidentifier from wtpart wt,wtpartmaster wtm,wttypedefinition wtd
    where wt.ida2typedefinitionreference =wtd.ida2a2 and wtm.ida2a2=wt.ida3masterreference and wtm.wtpartnumber like '0000001821'

     

    Fadel_0-1700793751576.png

     

     

     

    Buiꓘa
    View in thread

    2 replies

    Fadel
    Fadel23-Emerald IIAnswer
    23-Emerald II
    November 24, 2023

    try something  like below 

    select wtm.name,wtm.wtpartnumber,wtd.logicalidentifier from wtpart wt,wtpartmaster wtm,wttypedefinition wtd
    where wt.ida2typedefinitionreference =wtd.ida2a2 and wtm.ida2a2=wt.ida3masterreference and wtm.wtpartnumber like '0000001821'

     

    Fadel_0-1700793751576.png

     

     

     

    Translate
    Buiꓘa
      phsimard6-ContributorAuthor
      6-Contributor
      November 27, 2023

      Nice thank you! 


      Translate
      Terms & ConditionsAccessibility statement