Documentum Query Language is a derivative of SQL which can be used to For more information on DQL, please refer to Content Server DQL Reference guide. Posts about DQL written by HKRISH. Documentum is nothing other than a Content Management Tool but its vastness and its ability to cater to almost all sorts. The following DQL query identifies the lifecycle ID, current state, and the resume state (meaningful only if the current state is an exception state) for a document.

Author: Sagar Tarn
Country: Laos
Language: English (Spanish)
Genre: Relationship
Published (Last): 10 November 2010
Pages: 355
PDF File Size: 14.82 Mb
ePub File Size: 7.16 Mb
ISBN: 904-5-12528-683-5
Downloads: 48233
Price: Free* [*Free Regsitration Required]
Uploader: Douktilar

Some DQL Queries

In fact kVisia is an Enterprise Engineer product that encapsulates best practices and domain expertise. In order to use them, I recommend Qdman: Do you have any recommendations to help fix this issue? Traditional — VB Desktop. Fill in your details below or click an icon to log in: This is a user configurable application consisting of XML files managed by repository and standardized on a single ECM platform.

Documentum: some useful queries (DQL/IAPI)

December 11, at 5: Drop the Index if Necessary If there is no performance improvement, OR the optimizer is not using the new index, drop it using: October 10, at In fact, it can happen if someone saved a document, then deleted it right after. Properties A customized Properties dialog can be displayed.


Click here to download this study note PDF. Hi, search for one of my doubt wrt DQL landed me here. Lisa Loftis Contributors of the Year: October 30, at 2: Thus the concept of relationships and virtual documents can be used together to relate objects in Documentum using Documentum Foundation Classes DFC.

In the above figure the arrow denotes the relationship between two documents. The interception can be done as follows: Today the current era is defined by the terms like data, information, knowledge, wisdom etc.

The syntax for creating new indexes is as follows: How do you feel about the new design? This may result in a less efficient SQL query. I think the only Prerequisites that you need to know isBasic concept of client-server applications and Documentum Architecture.

Essentially, A, B and C represent different contracts. However want to observation on few common things, The website style is perfect, the articles is really excellent: Since tthe admin of this web site is working, no question vey soon it willl be renowned, due to itts quality contents. The workaround to continue with this query is typing go and pressing Enter again.

Please wait a few minutes and refresh this page. There are many constraints on modifying an existing attribute Refer to DQL Manual for more information. Top Create a free website or blog at WordPress. Notify me of new comments via email.


Sample DQLs – Ajith Prabhakar’s Weblog

You are commenting using your Twitter account. Jeannette, I guess I have to be a total geek, as people flip to me when they require help. Other specialized searching capabilities added for document and content management.

The attributes that can be searched on are configurable and search options such as Between, Greater Than, Containing, etc. Elements may have parent or child elements, and may also contain attributes. January 21, at 1: To maintain the relation across the current versions of document and for easy navigation from parent to child documents the concept of virtual documents in addition to documsntum of relationship was used.

Useful DQL Queries | Share Documentum Knowledge – Robin

To fetch all the results, set N to 0. The WordPress community is simply great and documejtum should experience it yourself. Fortunate me I found your website by chance, and I am stunned why this accident did not took place earlier!

Last modified: June 9, 2020