Skip to main content
A
Anish_K10-Marble
10-Marble
March 23, 2023
Solved

LWC Tables in Windchill DB

  • March 23, 2023
  • 1 reply
  • 1969 views

There are multiple tables with LWC* in windchill db. Does any one has idea about those tables?

 

 

Best answer by Anish_K

After looking at Article looks like in DB information of constraint is in BLOB format. so cannot query it.

I will try with Report Management as well.

1 reply

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
March 23, 2023

Hi @Anish_K 

The tables stores information about attribute definitions from type and attribute management layouts , constrains and so on. There are many things that are stored there. 

 

I would say Type and attribute management configuration storage. 

 

PetrH 

A
Anish_K10-MarbleAuthor
10-Marble
May 29, 2023

Actually I was trying to query those tables and let information about attributes, and its contraints.

But I am not able to get Enumeration constraint on specific attributes.

I have tried tables lwcbasicconstraint, lwcconstraintruledefinituion, lwcconstraintconditionlink.

 

I needed help in getting reation from lwcibadifinition to the constraints.

 

-Anish k

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
May 29, 2023

Take a look at this article

Is it possible to generate a Query Builder Report to list constraint values which are associated to IBAs in Windchill PDMLink

 

 

Marco
    Terms & ConditionsCookie settingsAccessibility statement