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: Grole Guk
Country: Paraguay
Language: English (Spanish)
Genre: Automotive
Published (Last): 6 March 2006
Pages: 146
PDF File Size: 5.90 Mb
ePub File Size: 9.97 Mb
ISBN: 348-5-29435-837-5
Downloads: 66469
Price: Free* [*Free Regsitration Required]
Uploader: Nigul

This means that if a rendition request failed 3 times in a row and succeed the last time, there eemc be 3 rows in the failed queue, but the rendition did succeed.

You can get these information thanks to the DQL query above. Email required Address never made public. It can be used to check if the dsearch is working fine and if reefrence indexing has been performed correctly. That means all document waiting for rendition. Thus, you may want to delete it.

Sample DQLs

Index Agent Info select fti. You are commenting using your WordPress. This one folder still has the old group and the new group in the permissions list.


Hi Ajith, Could you pl. In fact, it can happen if someone saved a document, then deleted it right after. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses. You are commenting using emv Twitter account. Be aware that it can take a while depending on the number of entries you have.

The following queries concern the rendition component.

I tried to reassign a group to a new group and the job worked except that it did not update one folder. Notify me of new comments via email.

Sample DQLs – Ajith Prabhakar’s Weblog

The parameter 60 can be changed. This query will return the number of items waiting to be indexed since 15 minutes. The indexing request remains in recerence queue for life.

December 12, at 12 h 57 min.

Many of you must be using Samson to do your DQL queries. It shows the dqll of the installer. This query flushes caches, it can be used when trying to install ADTS dars and fails due to version mismatch.

Any effort to remove it fails with this error: Infrastructure at rdference Service. If dq, it will return 0 results for a document that you know does exist in the docbase. Please also wmc that the default port is for the dsearch and for the index agent. This query displays the number of failed logons in the docbase per user since 60 minutes.


It regroups the rendition queue check and the way to manually ask a rendition reffrence IAPI. 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.

It is useful for the IAPI command returning the index agent status see below. This query returns your configured index agent information. In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below. Is it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute? This Query returns the failed renditions. If no rendition is present for the given document, it returns nothing.