Live report for knowing no of documents in each workspace number inside Some specific folder

Sreekanth_Bhojanapu

Hi Experts,

Actually I am new for Live reports, Please Can any one help for Query for live report.

knowing no of documents in each workspace  inside some specific folder.

Thanks
Sreekanth B

AJAP

Hello. To start, I recommend you see the DTree table.

Here is an example.

select d.dataid, d.name, count(c.dataid)-1 "count of items"

from dtree d, dtree c

where d.subtype = 848

and c.ownerid = d.dataid

group by d.dataid, d.name

order by count(c.dataid) desc

Hope it helps.

Regards