Which table in the Agile Database to look for page 3 and page 2 attributes?
The PAGE_TWO table holds most of the Page Two tab attributes (date, list multi-list, numeric, money, text, large-text), and the PAGE_THREE table holds most of the Page Three tab attributes (date, list multi-list, numeric, money, text). ID is the database id of the object to which the record belongs, and CLASS lets you know what type of object it is. All multi-text attributes are stored in AGILE_FLEX, where ID is the object ID, CLASS tells you the type of object and ATTID is the attribute ID. Note that all flex attributes are also held in the AGILE_FLEX table. All list/multi-list attributes hold ID values that link to LISTENTRY.
It may be worth noting that most object types (ITEMS, CHANGES, etc.) also have database VIEWS that already put the base object together with Page 2 and/or Page 3. For example, there are views called ITEM_P2, ITEM_P2P3, CHANGE_P2, and CHANGE_P2P3. I generally prefer those over querying directly from either the PAGE_TWO or PAGE_THREE tables. Hope that helps as well.
Steve
Hi Agile_User,
If you want to query for Items, Changes’ Page Two in Page Three, you can do this :
Select * from Item where ITEM_NUMBER=’XXXXXX’;
Select * from Page_Two where ID in (Select ID from Item where ITEM_NUMBER=’XXXXX’);
Select * from Page_Three where ID in (Select ID from Item where ITEM_NUMBER=’XXXXXX’);
Select * from Change where Change_Number=’XXXXX’;
Select * from Page_Two where ID in (Select ID from Change where Change_Number=’XXXXX’);
Select * from Page_Three where ID in (Select id from Change where Change_Number=’XXXXX’);
Regards,
Arif
I am using Agile Product Lifecycle Management 9.3.4.
Now i have another project to point to that Agile PLM. Now i want to get all the data but i dont know how to get the tab which the attribute belongs to?
Have anyone done with it before please help me.
Thank you