How does Agile PLm Database fetches Attribute and its values in Database ?

Answered

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.

Agile User Asked on May 29, 2020 in Agile PLM (v9).
Add Comment
2 Answer(s)
Best answer

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,

Steve LaLonde

Agile Professional Answered on June 2, 2020.

Thanks that helped a lot

on June 2, 2020.
Add Comment

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;

Agile Angel Answered on May 29, 2020.

Hi Steve,

Thanks for everything you told above. I actually need to write a query to find the values of a List and Multitext attribute of  Project Class object…struggling it to find in the database.

 

I was able to extract the ID of the particular project and also its number in Database table called “PROJECT_GENERAL_INFO_MV” but still unable to trace back the values stored in the particular List and Multitext attribute of  that particular Project Class object. Can you help ?

on May 31, 2020.
Add Comment

Your Answer

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