PropertyTable
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.
Hi Keithrust,
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 https://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
Hopefully the links sent by Arif help your understanding related to converting LDAP users to DB users as this is controlled in the agileuser table. The propertyid is used to identify different properties associated with the record. Here’s an example showing how the different Autonumber properties are configured based on different proertyids.
select n.description autonumber
, n.id
, n2.description subclass
, p1.value character_set
, p2.value number_of_characters
, p3.value starting_number
, p4.value prefix
, p5.value suffix
, (select last_number from all_sequences where sequence_name = ‘SEQAUTO’ || n.id) last_used_number
from nodetable n
inner join propertytable p1 on p1.parentid = n.id and p1.propertyid = 620
inner join propertytable p2 on p2.parentid = n.id and p2.propertyid = 55
inner join propertytable p3 on p3.parentid = n.id and p3.propertyid = 717
inner join propertytable p4 on p4.parentid = n.id and p4.propertyid = 56
inner join propertytable p5 on p5.parentid = n.id and p5.propertyid = 147
inner join adminmsatt a on a.value = n.id and a.attid = 57
inner join nodetable n2 on n2.id = a.parentid
where n.parentid = 5009
order by 1
;
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.
Hi Fatima,
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.
How to Convert a Database User to an LDAP User? (Doc ID 568607.1)
Regards,
Arif
