Sizing only current version under a folder and/or project

Pfizer_Developers

Hi there,I am looking for query and/or Live Report that will report back the size of the current version of all docs under that particular Parent. We have one for all versions whic is hereselect sum(d3.datasize)/(1024*1024) "Megabytes" from dtree d1, dtree d2, dversdata d3 where d1.dataid = d3.docid and d1.parentid = d2.dataid and d1.subtype in (0,144) and d1.dataid in (select dataid from dtree start with dataid = XXXXX connect by prior dataid = abs(parentid))What will do it for current versions?

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Haven't tested this, but what if you try:

 

select sum(d3.datasize)/(1024*1024) "Megabytes" from dtree d1, dtree d2, dversdata d3 where d1.dataid = d3.docid and dl.versionnum=d3.version and d1.parentid = d2.dataid and d1.subtype in (0,144) and d1.dataid in (select dataid from dtree start with dataid = XXXXX connect by prior dataid = abs(parentid))

 

The only modification I made above was to add "and dl.VersionNum=d3.Version " which I think should narrow the selection to the current version.

 

- Bhupinder

---

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, February 14, 2008 1:46 PM
To: eLink Recipient
Subject: Sizing only current version under a folder and/or project

 

Sizing only current version under a folder and/or project

Posted by pfizerdevteam (Developers, Pfizer) on 02/14/2008 01:44 PM

Hi there, I am looking for query and/or Live Report that will report back the size of the current version of all docs under that particular Parent. We have one for all versions whic is here select sum(d3.datasize)/(1024*1024) "Megabytes" from dtree d1, dtree d2, dversdata d3 where d1.dataid = d3.docid and d1.parentid = d2.dataid and d1.subtype in (0,144) and d1.dataid in (select dataid from dtree start with dataid = XXXXX connect by prior dataid = abs(parentid)) What will do it for current versions?