DQL-Documentum query

Question

Can any one please provide a solution in Documentum Query Language to access the folder details of a file checked out from documentum if we provide the object_id of the corresponding file. Thank You.......

Answer 1

You can try this dql: select * from dm_folder where r_object_id in (select i_folder_id from dm_document where r_object_id = '<objectId>')