Database Table that stores Page Two Fields Visible Flag


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
1 Answer(s)


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.


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

Your Answer

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