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: Zuhn Taur
Country: Barbados
Language: English (Spanish)
Genre: Marketing
Published (Last): 7 April 2009
Pages: 62
PDF File Size: 11.74 Mb
ePub File Size: 15.78 Mb
ISBN: 573-2-54046-545-5
Downloads: 70584
Price: Free* [*Free Regsitration Required]
Uploader: Jutilar

If no rendition is present for the given document, it returns nothing. Email required Address never made public. 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 refeernce.

Any suggestions would be helpful. This one simply puts an indexing request in the queue.

Sample DQLs – Ajith Prabhakar’s Weblog

You can get these information thanks to the DQL query above. This query returns all documents present in the rendering queue.

These are sample queries which will select one or more attributes from an Object and illustrates different where clauses. The indexing request remains in the queue for life.


Sample DQLs

So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue. Hi Ajith, I have the following query to list all documents and folders in a cabinet.

Leave a Reply Cancel reply Enter your comment here These examples are meant to give you a head-start on the basic DQL syntax. Be aware that it can take a while depending on the number of entries you have. This statement purges the audit trail queue smc deleting all logon failure entries.

Documentum: some useful queries (DQL/IAPI)

This query flushes reefrence, it can be used when trying to install ADTS dars and fails due to version mismatch. 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 query displays the number of sql logons in the docbase per user since 60 minutes. Any effort to remove it fails with this error: Please also note that the default port is for the dsearch and for the index agent.

You are commenting using your Facebook account. Please log in using one of these methods to post your comment: November 11, at 8 h 18 min. Thus, you may want to delete it.


April 27, at 10 h 36 min. October 15, at 11 h 11 min. This query returns your configured index agent information. That means all document waiting for rendition. The following queries concern the rendition component. Qdl are commenting using your Twitter account. It is useful for the IAPI command returning the index agent status see below.

July 31, at 8 h 21 min. Hi Ajith, Could you pl.

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

It regroups the rendition queue check and the way to manually ask a rendition through IAPI. This Query returns the failed renditions. But how can I list folders and documents in the same way as it is listing in Webtop folders are listed first in refrrence order, then documents are listed in sorted order.