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

How extract Display enumerated value of an object?

  • September 25, 2020
  • 1 reply
  • 8572 views

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

    1 reply

    H
    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

      A
      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?

       

       

       

      H
      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

        Terms & ConditionsAccessibility statement