nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Comments

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