Skip to main content
AndreaP8-Gravel
8-Gravel
September 25, 2020
Question

How extract Display enumerated value of an object?

Hello everybody, I'm trying to retrive some global enumerated value of WTDocument from the Windchill 11.0 M030 database with a SQL query.

 

I used the queries of https://www.ptc.com/en/support/article/CS174022

but what i can get are just the Internal values of the attributes, not the Display values.

(column NAME of [LWCEnumerationEntry])

 

Which table contains the DISPLAY Value of the enumerated attributes?

 

How these attributes values are linked to the objects (eg WTDocument) ?

I can see the stringValue linked to the object, but again it contains the internal value and I need instead the display value.

 

Can you point me to a datamodel documentation that covers this topic?

 

Thank you

    10 replies

    hlafkir5-Regular Member
    5-Regular Member
    September 25, 2020

    Hi,

     

    Please take a look into the LWCLocalizablePropertyValue table. here are the display values (with column for local)

     

    hlafkir_0-1601024822635.png

     

    good luck

    Translate
      AndreaP8-GravelAuthor
      8-Gravel
      September 28, 2020

      Thank you! now I'm able to see the display value in the database, LWCLocalizablePropertyValue.value

      and link it to the others tables

      LWCLocalizablePropertyValue.IDA3B4-->LWCEnumEntry.IDA2A2

      LWCEnumEntryLink.IDA3B4-->LWCEnumEntry.IDA2A2

      LWCLocalizablePropertyValue.IDA3C4-->LWCMasterEnumerationDefinition.IDA2A2

       

      I still miss how these values are linked to an object; 

      for example on  WTDocument normal strings vaues are linked :

      WTDocument <--(IDA3A4) stringValue (IDA3A6) --> stringDefinition

       

      How is the join in this case?

       

       

       

      Translate
      hlafkir5-Regular Member
      5-Regular Member
      September 29, 2020

      Hi,

       

      This article should help you to link the required tables :

       

      https://www.ptc.com/en/support/article?n=CS302379

       

      Hope this will help.

       

      Another hint :

       

      You can log SQL statements to see the query executed from Windchill to Database by using advices in this article :

       

      https://www.ptc.com/en/support/article/CS46545

       

      or, maybe better , add wt.pom.sql using the steps in Windchill GUI :

       

      https://www.ptc.com/en/support/article/CS145146

       

      This will show you how Windchill is building queries for any operations. Lot of lines 🙂

       

       

      Hicham

      Translate
        Terms & ConditionsAccessibility statement