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.
Hello
Please check propertytable->visible column. Parentid of this table will map to nodetable ID
– Raj
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.
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
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.
