How does Agile PLm Database fetches Attribute and its values in Database ?
Hey Can someone just help me know how does agile plm database gets to know a new attribute has been added to a class and how does it stores a all the values in it ? Is there any way we can know the location of table where all these newly added attributes or existing ones of Project class are located. I use sql developer to connect to db.
Just to make sure I understand, are you simply looking for the list values for a particular attribute on a particular object? Based on your response to Steve Jones above, I can’t tell if you’re saying you’re looking at a TABLE named “PROJECT_GENERAL_INFO_MV”, or if that is the name of your project object. Regardless, all objects have ties to Page Two and Page Three data via the object ID. So, as long as you can find the correct table your object is in, then you can get the associated P2 and P3 data for it. I believe you’ll find Project objects in the ACTIVITY table.
As for the list and multitext values, you must know the name of the column you’re trying to retrieve. Here’s an example:
Let’s say you have a project object named “My Project 0001” and the list and multitext attributes you’re trying to get are stored in LIST01 (PAGE_TWO) and MULTITEXT50 (PAGE_THREE). I recommend you just do sub selects for these attributes.
SELECT A.ID PROJID, A.NAME PROJNAME
,(SELECT ENTRYVALUE FROM AGILE.LISTENTRY WHERE ENTRYID = P2.LIST01) MY_LIST_VAL
–For Multitext you must know the attributes base ID
,(SELECT TEXT FROM AGILE.AGILE_FLEX WHERE ID = A.ID AND ATTID = 1567) MY_MTEXT_VAL
FROM AGILE.ACTIVITY A
INNER JOIN AGILE.PAGE_TWO P2 ON A.ID = P2.ID
WHERE A.NAME = ‘My Project 0001’;
I hope this helps,
As far as I know it is magic that the database is told to enable an attribute. But the attribute and its properties are kept in two main tables: NODETABLE and PROPERTYTABLE. Most everything is stored as number codes so it will be a bit difficult without a code sheet, which Oracle does not provide. For instance, non-page-three part attributes:
select description from nodetable where objtype = 1 and parentid = 10005;