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: Sadal Sharg
Country: Senegal
Language: English (Spanish)
Genre: History
Published (Last): 10 June 2012
Pages: 321
PDF File Size: 1.87 Mb
ePub File Size: 2.18 Mb
ISBN: 163-9-28895-696-5
Downloads: 63045
Price: Free* [*Free Regsitration Required]
Uploader: Akilkis

In fact, it can happen if someone saved a document, then deleted it right after.

Sometimes I noticed there are indexing requests on deleted documents. It is useful for the IAPI command returning the index agent status see below. First, check if the file is deleted by running the IPAI: The indexing request remains in the queue for life. Can you please let me know if there is way to convert an ASCII referemce to pdf and file to Documentum so that a user and search on it. Hi Ajith, Could you pl.

These examples are meant to give you a head-start on the basic DQL syntax. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses.

Sample DQLs

Many of you must be using Samson to do your DQL queries. Notify me of new comments via email. This query displays the number of failed logons in the docbase per user since 60 minutes. Referece it possible using DQL query to see whether an attribute name for an object type is a repeating attribute or single attribute?


Documentum: some useful queries (DQL/IAPI)

The following queries concern the rendition component. This Query returns the failed renditions. Infrastructure at your Service. April 21, at 9 h 03 min. Click here to download this study note PDF. December 12, at 12 h 39 min.

Sample DQLs – Ajith Prabhakar’s Weblog

July 31, at 8 h 21 min. It regroups the rendition queue check and referebce way to manually ask a rendition through IAPI. Leave a Reply Cancel reply Enter your comment here 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? October 15, at 11 h 11 min. In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below. If no rendition is present for the given document, it returns nothing.

This query returns your configured index agent information. It shows the version of the installer. You are commenting using your Twitter account. Refference one simply puts an indexing request in the queue.

Thus, you may referene to delete it. 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. Teference can get these information thanks to the DQL query above.

Any suggestions would be helpful. Note that the parameter can still ne changed. So you should verify refegence the rendition did succeed and if so, you can delete the row form of the failed queue. This query flushes caches, it can be used when trying to install ADTS dars and fails due to version mismatch.


November 23, at 9 h 22 min. This will return object id and name of all the objects that was created between today and If not, it will return 0 results for a document that you know does exist in the docbase. This one folder still has the old group and the new group dqql the permissions list.

It can be useful when scripting or in DFC programs.

I am a total newbie at this and found your extremely useful blog with related matters and hope you can help. Note that you have to replace the Indey Agent information in the first line by your Index Agent. That means all document waiting for rendition.

EMC Community Network – DECN: DQL reference

I tried to reassign a group to a new group and the job worked except that it did not update one folder. Please also note that the default port is for the dsearch and for the index agent.

Please log in using one of these methods to post your comment: This query returns all documents present in the rendering queue.