I want to retrieve the folder path for a specific document
How can i retrieve this using DQL
Try something like this:
select r_folder_path from dm_folder where r_object_id in (select i_folder_id from dm_sysobject where r_object_id = '<object id of your object>');
That's the way I do it
select A.r_object_id, A.object_name, B.r_folder_path from dm_document A, dm_folder_r B where any A.i_folder_id = B.r_object_id and B.r_folder_path ='/Folder_name';
Thank you very much. It really helped a lot
once again thanks
