Thursday, October 08, 2009

Documentum DQL to retrieve latest version of an object

To find the latest version of a dm_document from documentum based on r_object_id, use the following dql.
select r_object_id from dm_document where i_chronicle_id in (select i_chronicle_id from dm_document(all) where r_object_id = '?')