Live Report - Count all Folders and Sub Folders

Victor_Prasad

Hello,

We have an existing report that lists all documents under a folder.  I just want to see the folders not documents.  What do I change?

Here is what I have:

select dtree.dataid || '|' || sys_connect_by_path(name,':') "NodeID|Path|FileName"
from dtree
where dtree.subtype = 144
start with dtree.dataid = %1
connect by prior dtree.dataid = dtree.parentid
order by dtree.dataid

 

Thanks,

 

Nizar Ghazal

Quoted Victor Prasad on 04/12/2017 04:56 PM:

Hello,

We have an existing report that lists all documents under a folder.  I just want to see the folders not documents.  What do I change?

Here is what I have:

select dtree.dataid || '|' || sys_connect_by_path(name,':') "NodeID|Path|FileName"
from dtree
where dtree.subtype = 144
start with dtree.dataid = %1
connect by prior dtree.dataid = dtree.parentid
order by dtree.dataid

 

Thanks,

 

 

Hi Victor,

Just looking at this real quick, without testing:

where dtree.subtype = 144

Your condition is set by the subtype of 144, which is the subtype for documents. Try changing it to 0, which is the folder subtype. Run it again, and see if it has the intended results.

Thanks.