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 = '?')