Calculating Folder Size and sub-folders including Files in Projects and sub-projects

I have a Livereport that calculates the size in MB of all the files in the folder and subfolders.I am looking for help in modifying the report where it will also calculate the files within a Project and sub-projects. Current Livereport does not calculate any files that are within a Project.Here's an example of the Livereport:SELECT (SUM (datasize))/1024 FROM dversdata WHERE docid IN (SELECT dataid FROM dtree START WITH dataid = "objID" CONNECT BY PRIOR dataid = parentid)

Find more posts tagged with

Comments

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Jonathan,

Projects have their own workspace. Your "connect by" does not cross workspace boundaries at the moment.

To do this, you need to allow the sign of the dataid and parentid to change. It needs to be both so that you get to sub projects.

So you need PRIOR abs(dataid) = abs(parentid)

This might be inefficient (= slow) - Oracle will not find an index on abs(dataid) or abs(parentid) in the default schema.

Don't run this from the Enterprise down, then. :-)

Regards

Lindsay

EU-Escalation Team

Open Text

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 03 September 2009 17:07
To: eLink Recipient
Subject: Calculating Folder Size and sub-folders including Files in Projects and sub-projects

Calculating Folder Size and sub-folders including Files in Projects and sub-projects

Posted by nsscadmin (Miller, Jonathan) on 2009/09/03 12:06

I have a Livereport that calculates the size in MB of all the files in the folder and subfolders.

I am looking for help in modifying the report where it will also calculate the files within a Project and sub-projects. Current Livereport does not calculate any files that are within a Project.

Here's an example of the Livereport:

SELECT (SUM (datasize))/1024 FROM dversdata WHERE docid IN (SELECT dataid FROM dtree START WITH dataid = "objID" CONNECT BY PRIOR dataid = parentid)

ray_chance

Thanks a lot. It worked.