Query to get the folder structure hierarchy in documentum

Hi All,

Please help me resolve this

How to generate the hierarchy in documentum for a docbase using DQL query. That is how to get data for populating a tree like structre for a given pub.

By using the DQL : select r_folder_path,object_name from dm_folder where folder('/cabinet1',descend) we can get all the folders in that cabinate but i need the result with the folder structure hierarchy.

Is there any approch to get this with the DQL or any logic that we can apply using DFC code.

Thanks in advance.

Regards,

Tej.

Find more posts tagged with

Comments

DCTM_Guru

Have you tried ordering the results:

select r_folder_path,object_name from dm_folder where folder('/cabinet1',descend) order by 1

Tej

Thanks for the replying....

I got a DFC code that is performing the folowing operation.

Create a IDFolder object of the root folder.

Then fire IDFolder.contains() this would give all the objects that are in the folder.

check if you have a folder in it by the object id.

call the above function recurricsively.

Let me know if you want the DFC code I can share it with you ....

Thanks & Regards,

Tej.

anu1

Hi,

Can you please share the DFC code?

Thanks in advance.

msroth

How about a DQL like this:

SELECT fr.r_folder_path, count(*) as cnt, sum(r_full_content_size)/1024 as sizeKB FROM dm_sysobject s, dm_sysobject_r sr, dm_folder_r fr, dm_document dm WHERE s.i_is_deleted = 0 AND sr.i_position = -1 AND fr.i_position = -1 AND sr.r_object_id = s.r_object_id AND fr.r_object_id = sr.i_folder_id AND dm.r_object_id = s.r_object_id AND FOLDER('/Temp', descend) GROUP BY fr.r_folder_path

Results look like this:

r_folder_path                           cnt  sizekb
/Temp                                   2     3
/Temp/Jobs/dce_Clean                    2     2
/Temp/Jobs/dm_ContentWarning            3     11
/Temp/Jobs/dm_DataDictionaryPublisher   14    36
/Temp/Jobs/dm_FTCreateEvents            2     5
/Temp/Jobs/dm_FTIndexAgentBoot          5     6
/Temp/Jobs/dm_FTStateOfIndex            1     1
/Temp/Jobs/dm_GwmClean                  3     0
/Temp/Jobs/dm_GwmTask_Alert             9     0
/Temp/Jobs/dm_QmPriorityAging           5     5

If you don't need the object count and size you can modify it as needed.