Determining the size of the Folder

[livetoday]

Hi,

I am having trouble trying to write a Livereport which calculates the folder size that you select. For example, I select a folder and in that folder are documents, drawings, etc... I need to determine the total size of the folder which includes these objects. (MB or GB)..so far I have written the following:

select sum(datasize) from dversdata where docid in (select dataid from dtree start with dataid=() connect by prior dataid=(parentid)) and mimetype = 'image/hpgl.plt'

The above does not give me what I want,,, does anyone have an idea?

Thanks!

 

[appnair]

I am not seeing what your problem is.Does the SQL query not run in an oracle instance of livelink.Are you trying this query against SQLserver.Run the inner query first to see if you have all the dataid's.I also just reversed the where here so it becomes a little more readable.It could alos very well be that the mimetype of that value is not there in the database.

select sum(datasize)/1024/1024 as "MB" from dversdata where mimetype like 'image/hpgl.pl*' and  docid in (select dataid from dtree start with dataid=<"a valid folder id" > connect by prior dataid=parentid)

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937