Hai,
I would need some advise on the Treeview Container only report. The query is as below, I would like to add the Size in MB column for the containers. Can someone help me out pls.
select parentid " parent-id " , dataid "Objid" , level, decode(subtype, 202 , 'P' , 0 , 'F' ) " Type " ,
substr(lpad( '____________________________________________________________________________________________________' , 5* (level- 1 )) ||d1.name,0 , 100 ) "Objectname" ,d1.name " Object " ,
nvl( d1.childcount , 0 ) "ChildCount" , d1.createdate "Created" , decode( D1.CREATEDBY ,
D1.CREATEDBY ,(select name from kuaf where id = d1.createdby )) "Created By " ,
decode( d1.userid , d1.userid ,(select k1.name from kuaf k1 where k1.id = d1.userid )) "Owner" ,
d1.modifydate "ModifyDate" , d1.versionnum " Number of versions " ,decode( D1.VERSIONNUM , D1.VERSIONNUM ,
(select dv.mimetype from dversdata dv where dv.version = d1.versionnum and dv.docid = d1.dataid )) "MimeType" ,
ll_path ( d1.dataid ) "Folder Path" from dtree d1 connect by prior d1.dataid = abs(d1.parentid )
and level <= 4 and d1.subtype in( 0,202 ) start with d1.dataid = 123459341
