Home General

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

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

Sign In or Register to comment.