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: Kagarisar Goltizragore
Country: Bulgaria
Language: English (Spanish)
Genre: Career
Published (Last): 3 October 2009
Pages: 42
PDF File Size: 17.63 Mb
ePub File Size: 13.15 Mb
ISBN: 192-5-54477-271-5
Downloads: 41677
Price: Free* [*Free Regsitration Required]
Uploader: Felar

April 27, at 10 h 36 min.

EMC Community Network – DECN: DQL reference

Please log in using one of these methods to post your comment: Thus, you may want to delete it. Be aware that it can take a while depending on the number of entries you have.

December 12, at 12 h 57 min. Hi Ajith Is it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute? 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.

This query returns your configured index agent information. Please also note that the default port is for the dsearch and for the index agent. This will return object id and name of all the objects that was created between today and July 31, at 8 h 21 min.

You are commenting using your WordPress. Click here to download this study note PDF.

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 11, at 8 h 18 min.


First, check if the file is deleted by running the IPAI: You can get refwrence information thanks to the DQL query above. Hi Ajith, I have the following query to list all documents and emcc in a cabinet.

That means all document waiting for rendition. The parameter 60 can be changed. Many of you dqp be using Samson refersnce do your DQL queries.

So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue. These examples are meant to give you a head-start on the basic DQL syntax.

October 15, at 11 h 11 min. I am a total newbie at this and found your extremely useful blog with related matters and hope you can help. In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below.

I tried to reassign a group to a new group and the job worked except that it did not update one folder. Hi Ajith, Could you pl. Any effort to remove it fails with this error: Notify me of new comments via email.

If not, it will return 0 results for a document that you know does exist in the docbase. November 23, at 9 h 22 min.

Sample DQLs

You are commenting using your Twitter account. 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.


Note that the parameter can still ne changed. The workaround to continue with this query is typing go and pressing Enter again.

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

This query will return the number of items waiting to be indexed since 15 minutes. Email required Address never made public. Any suggestions would be helpful. This statement purges the audit trail queue by deleting all logon failure entries.

This query returns all documents present in the rendering queue. Sometimes I noticed there are indexing requests on deleted documents. Brand new to Documentum. It is useful referencr the IAPI command returning the index agent status see below.

It regroups the rendition queue check and the way to manually ask a rendition through IAPI. Can you please let me know if there is way to convert an ASCII file to pdf and referrnce to Documentum so that a user and search on it. These are sample queries which will select one refference more attributes from an Object and illustrates different where clauses. Leave a Reply Cancel reply Enter your comment here It shows the version of the installer.

Need a DQL query to find the total number of documents present and total size utilized in docbase. Check its log file, it normally contains all these information already.