You Got Empty Folders!

Posted by Sumeet on Sep 29, 2007 in Documentum |

How to find empty folders in the entire docbase?

SELECT r_object_id, object_name, r_object_type, r_folder_path

FROM dm_folder f

WHERE r_object_id NOT IN(SELECT distinct i_folder_id

FROM dm_sysobject

WHERE any i_folder_id = f.r_object_id)

How to find just empty folders in a cabinet?

SELECT r_object_id, object_name, r_object_type

FROM dm_folder f

WHERE r_object_id NOT IN(SELECT distinct i_folder_id

FROM dm_sysobject

WHERE any i_folder_id = f.r_object_id

AND FOLDER(‘/cabinet_name’, DESCEND))

AND FOLDER(‘/cabinet_name’, DESCEND)

Reply

 


Copyright © 2017 dm_maniacs All rights reserved. Theme by Laptop Geek.

wordpress stats