Document counter

Birger_Jacobsen_(danskadmin_-_(deleted))

Can anybody help me with a report to count the number of documents in the subfolders but ordred ordered top folderwe have about 2300 top folders with about 5 to 10 sub folder in every top folder.Eks..top folder......subfolder (10 doc)......subfolder (7 doc)..........sub-sub folder (8 doc)OutputTop foldername (25 doc)I tryed this but.....Select name, Childcount from dtree where subtype = 144Thank you

Find more posts tagged with

Comments

HPC_Plant_2_(x-unilev033_-_(deleted))

I am looking to provide the same type of report. Where you able to find a way to provide your final output?I would be very interested in looking at the SQL statement(s).Thanks.Sean

***_****_(citlon01admin_-_(deleted))

Use the following to create a tree view of the enterprise folder structure. This is with Oracel DB.Create or replace view COL_TreeView asselect dataid, level TreeLevel, lpad('..',3 * level -1)|| Name Name from dtree start with dataid = 2000connect by parentid = prior dataidWe name all the new table created with COL_ for the City of London. This will hopefully eliminate and conflict in naming conventions with LivelinkThe following should workSelect col_treeview.name, count(dtree.dataid) where dtree.dataid = col_treeview.dataid and dtree.subtype = 144 group by dtree.parentidI have not tested it, but in theory it should work. The view will at least get the folder structure.Hope this helps.