Documentum DQL to select r_folder_path from r_object_id

You have to run a couple of DQL statements. Here are the steps:

1. select i_folder_id from dm_document where r_object_id = ‘myObjectId’
2. Retrieve the value returned, now known as myFolderID
3. select r_folder_path from dm_folder where r_object_id = ‘myFolderID’