These examples are meant to give you a head-start on the basic DQL syntax. For more information on DQL, please refer to Content Server DQL Reference guide. EMC® Documentum® Content Server Version DQL Reference EMC Corporation Corporate Headquarters: Hopkinton, MA This guide is the reference manual for the EMC Documentum object hierarchy. to EMC Documentum Content Server DQL Reference, EMC Documentum.

Author: Gagor Douzragore
Country: Italy
Language: English (Spanish)
Genre: Politics
Published (Last): 11 January 2009
Pages: 336
PDF File Size: 12.54 Mb
ePub File Size: 3.76 Mb
ISBN: 663-3-36807-442-2
Downloads: 14387
Price: Free* [*Free Regsitration Required]
Uploader: Faunos

Notify me of new referene via email. Brand new to Documentum. Is it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute? As the indexing request, this one puts a PDF rendition request in the queue. This statement purges the audit trail queue by deleting all logon failure entries.

Click here to download this study note PDF. Please log in using one of these methods to post your comment: Index Agent Info select fti. Note that the parameter can still ne changed. It can be used to check if the dsearch is working fine and if the indexing has been performed correctly. The indexing request remains erference the queue for life.

So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue. Infrastructure at your Service.

Sample DQLs

Many of you must be using Samson to do your DQL queries. First, check if the file is deleted by running the IPAI: You can get these information thanks to the DQL query above.


But how can I list folders and documents in the same way as it is listing in Webtop folders are listed first in sorted order, then documents are listed in sorted order. November 23, at 9 h 22 min. July 31, at 8 h 21 min. You can create a PDF rendition of a Acsii file, for that you need a PDF converter plugin, for searching within the contents of a file you should have full text search enabled on that content server.

In order to use them, I recommend Qdman: This means that if a rendition request failed 3 times in a row and succeed the last time, there will be 3 rows in the failed queue, but the rendition did succeed. It can be useful when scripting or in DFC programs.

Sample DQLs – Ajith Prabhakar’s Weblog

November 29, at referemce h 51 min. This will return object id and name of all the objects that was created between today and This one simply puts an indexing request in the queue.

Any suggestions would be helpful. In fact, it can happen if someone saved a document, then deleted it right after. Email required Address never made public.

Documentum: some useful queries (DQL/IAPI)

These examples are meant to give you a head-start on the basic DQL syntax. The following queries concern the rendition component. That means all document waiting for rendition. The workaround to continue with this query is typing go and pressing Enter again.

Any effort to remove it fails with this error: December 12, at 12 h 57 min. Sometimes I noticed there are indexing requests on deleted documents. This query returns your configured index agent information. Leave a Reply Cancel reply Enter your comment here If no rendition is present for the given document, it returns nothing.


It regroups the rendition queue check and the way to manually ask a rendition through IAPI. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses. Please also note that the default port is for the dsearch and for the index agent.

Documentum: some useful queries (DQL/IAPI) – Blog dbi services

October 15, at 11 h 11 min. The parameter 60 can be changed. Note that you have to replace the Indey Agent information in the first line by your Index Agent. You are commenting using your WordPress. It shows the version of the installer. This query flushes caches, it can be used when trying to install ADTS dars and fails due to version mismatch. Need a DQL query to find the total number of documents present and total size utilized in docbase.

reterence It is useful for the IAPI command returning the index agent status see refeerence. This one folder still has the old group and the new group in the permissions list. April 21, at 9 h 03 min. Check its log file, it normally contains all these information already. Can you please let me know if there is way to convert an ASCII file to pdf and file to Documentum so that a user and search on it. April 27, at 10 h 36 min.