Documentum - getting a list of sub folders

Question

Is there a way in Documentum to get all sub folders of a folder? Can someone suggest a DQL or some thing where I can specify a parent folder and the DQL returns me a folder path of all the sub folders.

Answer 1

select distinct r_folder_path from dm_folder where folder('/Folder1/Folder2', descend)

This will return all the folders and subfolders under /Folder1/Folder2