Exactly look for a pdf in a emc documentum using rest api using dql
Im trying to use dql. My objective was to search for a pdf. For example the naming conventions of pdfs are like amd-1-prot MA-NI-123-1234.pdf or prot MA-NI-123-1234.pdf. I was able to search the exact folder using the dql query \dql?=select * from dm_folder where object_name="fOLDER_NAME". I dont know how to search for exact pdf with a pattern. .
Comments
-
I struggle to understand your question, but are you just trying to find documents with name ending in '.pdf'?
If so, this is a possible DQL:SELECT r_object_id, object_name FROM dm_document WHERE object_name LIKE '%.pdf'
Pedro Maia
Senior Consultant
OpenText0 -
If you are looking for a document whose primary format is PDF, don't query for the filename (especially not with a wildcard at the beginning which is terrible for performance). Instead use the a_content_type attribute. You are not on a file system anymore!
select * from dm_document where a_content_type = 'pdf'0
Categories
- All Categories
- 108 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 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
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management