Count Documents Under a Project including documents in sub-folder and sub-Projects

ray_chance

Our customers wants a report of all the files under their Project workspace. Their project workspace contains several sub-folders and sub-projects with files as well. They want the Livereport to capture those files as well. Just wondering if this SQL statement is the most efficient way of doing it...select count(*) from dtree where subtype in(144,136,202)start with dataid = %1 connect by parentid = prior dataid

Andrew_Ormesher_(andrew.ormesher@fastman.net.au_(D

Hi,Just be careful that your SQL will include all documents - a dataid of a project workspace (say 12345) will become -12345 as a parentid of any immediate child objects - something about it being a workspace. Just make sure any where or join clause in your SQL accounts for this scenario...Cheers!Andrew FCS Australia