Leave a comment

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: Gardasar Akizil
Country: South Africa
Language: English (Spanish)
Genre: Environment
Published (Last): 10 July 2014
Pages: 42
PDF File Size: 18.40 Mb
ePub File Size: 9.40 Mb
ISBN: 959-5-85502-756-8
Downloads: 80055
Price: Free* [*Free Regsitration Required]
Uploader: Vucage

The parameter 60 can be changed. The indexing request remains in the queue for life. If no rendition is present for the given document, it returns nothing. These examples are meant to give you a head-start on the basic DQL syntax.

Sample DQLs – Ajith Prabhakar’s Weblog

There are many constraints on modifying an existing attribute Refer to DQL Manual for more information. This Query returns the failed renditions.

November 29, at 9 h 51 min. November 11, at 8 h 18 min. December 12, at 12 h 39 min. These are sample queries which will select one or more attributes from an Object and illustrates different where clauses. This query returns all documents present in the rendering queue. Index Agent Info select fti.

This will return object id and name of all the objects that was created between today and It regroups the rendition queue check and the way to manually ask a rendition through IAPI. Email required Address never made public.

Any suggestions would be helpful. Any effort to remove it fails with this error: This query returns your configured index agent information.

That means all document waiting for rendition. The following queries concern the rendition component. This query displays the number of failed logons in the docbase per user since 60 minutes. You are commenting using your WordPress. The workaround to continue with this query is typing go and pressing Enter again. 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.


I am a total newbie at this and found your extremely rfference blog with related matters and hope you can help.

Notify me of new comments via email. So you should verify deference the rendition did succeed and if so, you can delete the row form of the failed queue. This one simply puts an indexing request in the queue. Please referencce in using one of these methods to post your comment: Many of you must be using Samson to do your DQL queries.

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? But how can I list folders and documents in reverence same way as it is listing in Webtop folders are listed first in sorted order, then documents are listed in sorted order. In order to use them, I recommend Qdman: In fact, it can happen if someone saved a document, then deleted it right after. If not, it will return 0 results for a document that you know does exist in the refference.

Note that the parameter can still ne changed. Hi Ajith, Could you pl. Check its log file, it normally contains all these information already. Please also note that the default port is for the dsearch and for the index agent.


Documentum: some useful queries (DQL/IAPI)

You can get these information thanks to the DQL query above. 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. 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?

Need a DQL query to find the total number of documents present and total size utilized in docbase. You are commenting using your Twitter account. This statement purges the audit trail queue by deleting all logon failure entries. This query will return the number of items waiting to be indexed since 15 minutes.

It shows the version of the installer. October 15, at 11 h 11 min. April 21, at 9 h 03 min. You are commenting using your Facebook account.

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. Infrastructure at your Service.

November 23, at 9 h 22 min. Brand new to Documentum. It can be used to check if the dsearch is working fine and if the indexing has been performed correctly. Click here to download this study note PDF.