LWC Tables in Windchill DB

[Anish_K]

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

[HelesicPetr]

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 

[Anish_K]

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]

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

[Anish_K · Accepted solution]

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.

[Marco_Tosin]

How to display BLOB data in Query Builder reports in Windchill

How to deserialize BLOB data for attributes for which the value is stored in vaults

Hope this could help you.