I am a total newbie in Agile PLM. I want to ask that what is the use of ‘propertytable’ in agile and from where does ‘propertyid’ attribute comes in this table? Also what is its use in usertype conversion? Any further details would be appreciated.
Thanks for the information that you provided. And by usertype I mean that to convert a DB user to an LDAP user, how can we utilize propertytable? I am referring to this post http://myagileplm.com/question/can-we-convert-an-existing-agile-user-to-an-ldap-account/ I cannot figure out the role of property table in this task. Also, can you tell about “PropertyID’ in PropertyTable, is it a foreign key from some table or something? Thanks
In general, adminmsatt, nodetable, and propertytable all work together to manage the system configuration. When you look at the Java Client Admin tab you see a bunch of nodes in a tree. Each node has properties and sometimes the properties are multilist values (nodetable, propertytable, and adminmsatt respectively.) Parentid in nodetable will be the parent in the tree. Parentid in propertytable is the node the property applies. Please explain what you mean by usertype conversion.
To see what the definitions for PROPERTYID are, run the query :
select entryid,entryvalue from listentry where parentid=181;
PROPERTYTABLE is used to define the “properties” of various types of things in NODETABLE. PROPERTYID lets you know which property is being defined. The string that is in VALUE is what the property is (like ITEM.CATEGORY being the database attribute, propertyid=10). Except for propertyid=15, where the ID of the list assigned to the attribute is actually in SELECTION, not VALUE.
Please see the attached document for reference. It has detailed steps of migrating all db users to ldap or migrating a particular users from db to Agile.