DQL to retrieve docs linked to two locations of same cabinet
Hi,
I need a DQL query to generate list of documents linked to two or more locations of same cabinet. For example, the document ABC is linked to /Record Centers/New York/.., /Record Centers/Chicago/.., /File Plan/xyz/.. and /Test/a123/... As this document is linked to same cabiner /Record Centers, this should show as a result. I want this query to be run on whole repository to get the list of documents.
Any help is greatly appreciated.
Thanks,
Umesh
Comments
-
Can anyone please help me with the DQL query to accomplish this task.
0 -
Try UNION
DQL 1 (.. where FOLDER('/Record Centers/New York', descend)
union
DQL 2 (.. where FOLDER('/Record Centers/Chicago', descend)
union
DQL 3 ( ..where FOLDER( 'File Plan/xyz', descend)
etc..
0 -
Are you looking for the docs with more than one i_parent_id?
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management