Live report for knowing no of documents in each workspace number inside Some specific folder
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
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
0
Comments
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