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

No Files Were Attached
priyanka Agile User Asked on September 26, 2018 in Product Collaboration.
Add Comment
2 Answer(s)
Best answer

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

priyanka Agile User Answered on September 26, 2018.
Add Comment

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.

Kevin Cummings Agile Angel Answered on September 26, 2018.
Add Comment

Your Answer

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