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

FIND NAME of WTDocument SubType in SQL Windchill

  • November 23, 2023
  • 1 reply
  • 1133 views
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.
    Best answer by Fadel

    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

     

     

     

    1 reply

    Fadel
    Fadel23-Emerald IAnswer
    23-Emerald I
    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
      P
      phsimard6-ContributorAuthor
      6-Contributor
      November 27, 2023

      Nice thank you! 


      Terms & ConditionsAccessibility statement