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.
Open Search Builder:
And click Add Criteria.
You could try the following query instead to find folders that has less than 3 documents inside:
$FIELD$ in (select o_projguid from dms_doc group by o_projguid having COUNT(o_projguid) <= 3)
Just this query does not include the empty folders, so the searches would have to be used together.
Is there a way to search just the Project folders instead of all folders? We have many templates that were created in the beginning years of our PW implementation and were never used. These empty Project folders may have 2 to 3 default files in them as well. I would like to be able to search for Projects with <= 3 files. Is this possible?