Dql query for count of linked documents in a cabinet
Options
Comments
-
Try something like:
SELECT * FROM dm_document d
WHERE FOLDER('/Cabinet_Name', descend)
AND EXISTS
(
SELECT * FROM dmr_content r
WHERE ANY r.parent_id = d.r_object_id
AND r.full_format = 'pdf'
)Pedro Maia
Senior Consultant
OpenText0 -
@PedroMaia thanks for the comment, but it only specifies for pdf, I need to know about all the rendition formats being used in one single cabinet.
Consider this,
I want to know count of all the documents that have renditions, rendition format and size of that rendition in one cabinet. I am doing volumetric analysis for migration to SharePoint0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax