Background

Creating ProjectWise Projects from templates might be creating loads of empty folders even after the project is completed. And it might be reasonable to clean up empty folders after the Project is completed to save space in database and reduce amount of records.

This method helps to find all folders (depending on specific search criteria) that does not have any documents inside them or any sub folders.

Steps to Accomplish

To find empty folders we can use the ProjectWise Search builder:

1. Open ProjectWise Explorer and log in to datasource

2. Open Search Builder:
   
   

3. Select Look for: Projects and Folders; Criterion Type: General Properties; Property: Folder GUID; for value we use custom query:
   $FIELD$ in (select o_projguid from dms_proj where o_projguid not in (select o_projguid from dms_doc) and o_subprojects='N')
   
   
   
   

4.  And click Add Criteria.

5. In addition we can define additional parameters, like for example a parent folder to look for empty folders in. For that we add Property: Parent Folder and select the required folder from ProjectWise.
6. Running this search will find all folders that does not have any documents inside them and no sub folders.
7. After finding all these folders we can then delete them, or mane any other required action.
8. If needed this search can be executed few times, so that higher level folders would also be found (after removing their child folders)