How we would get the list of all folders & sub-folders from the content repository DFC.

How we would get the list of all folders & sub-folders from the content repository of the WebTop. There are more than 10 folders in the cabinet but I am only getting information about the home cabinet only.

I am working on a utility which would get the documents from one folder and upload in the other folder after conversion in other format (batch utility).Original document will delete after the conversion complete.

I need the list of all folders and sub-folder to provide the option for user so that he/she can select the target folder in the content repository.

Find more posts tagged with

Comments

DCTM_Guru

How are you getting info in the home cabinet? You can get list of all cabinets that you have access to by querying for all cabinets:

select r_object_id, object_name from dm_cabinet

mfernandezv

Hi,

I think you could get the list using

select object_name, title, from dm_sysobject WHERE TYPE("dm_folder") and i_parent_id = <your_folder_id>

or you can query dm_folder directly and use the folder predicate:

select object_name, title from dm_folder where FOLDER (’/cakes/yeasted’, DESCEND)

DESCEND applies to all folders specified in the predicate

Hope that helps!

Regards