Agile File Folder subclass object id and title block info using query
Hi,
I want to get title block,page 2 and page 3 information of my agile object whose type is sub class of file folder.
I know about page_two and page_three table but i unable to get id of my object and title block information.
Can anyone tell me which table used in agile to store file folder object information.
Thanks
Priyanka
Hi,
After struggling whole day and after posting question on myagileplm community i just click on view tab of my TOAD where i found view agile_objects where i get to know that attachment table is a table where file folder entry is made similar like item ,psr,change table.
So i made a query with attachment table to get id of my particular object join with page_two and page_three table and for list type value again join entry id with listentry table.
All in all my purpose resolved.
Thanks for your concern.
Thanks
Priyanka
Yes, File Folders are in the ATTACHMENT table.
You can also use the ATTACHMENT_P2P3 view, it provides all the attributes you want and you only reference a single object. Easier to use than having to make sure you have all the joins correct, etc.
