Database Table that stores Page Two Fields Visible Flag

Hi,

I want to know the table in the agile database that stores the visibility information of page two fields on front-end (i.e is the field visible/enabled on front-end or not).

Any help in this matter would be much appreciated.

 

 

Agile User Asked on July 20, 2020 in Agile PLM (v9).
Add Comment
2 Answer(s)

Hello

Please check propertytable->visible column. Parentid of this table will map to nodetable ID

– Raj

Agile Expert Answered on July 20, 2020.

I have checked it. But it doesn’t get updated when I enable/disable a field from front-end. Furthermore, do you have an idea if any table stores information of page two fields per subclass (instead of class)? I have observed that some page two fields are enabled for one part-subclass and disabled for the other ones.

on July 21, 2020.

Hello

You are right. Visible column doesn’t change. However, the “value” column does.

I believe this query should tell you all fields that have visible set to false

select * from agile.propertytable where propertyid = 9 and value = 0 and visible = 1 and selection = 451. Give this a try and see if it works

I have yet to figure out how Agile stores the scenario where an attribute is set to false for certain subclasses

– Raj

 

on July 22, 2020.

Hi. Thanks it worked. But I am still wondering if I can find something regarding it on subclass level.

on July 23, 2020.

Good that this worked. Will try to see if i can find something for subclass level setting

on July 23, 2020.
Add Comment

It looks like when a P2 field is turned off, or on, at a subclass level, there is a new record added to the nodetable where the description and name is the ID of the attribute and the parentid refers to a RootSubClassP1P2 node. The propertytable contents associated with this inserted record include visibility, propertyid = 9, reference to the attribute id, propertyid = 953, reference to the table, propertyid = 954, and reference to the subclass, propertyid = 955.

Agile Angel Answered on November 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.