Sizing only current version under a folder and/or project

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?

Find more posts tagged with

Comments

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?

Mark_Teague

I would probably employ a max() aggregate on the version field to obtain the most recent version; and then, join that back as a filter to obtain the datasize of only the latest version.Mark