[Help] Files number and total size in a specific folder

[NaturelBenton]

Hi,

I'm a bit stuck! I would like to list the number of elements (files like office documents, pdf and so on) in a specific folder and the total size of these files.

Im wondering if it's possible to do that using a LiveReport and a SQL query on (not only this one i guess) the DTREE table (if i use the id of the root folder, i guess it's possible to loop on the different sub nodes and calculate that but i'm a bit stuck at this point).

Any solution is welcomed of course!

Thanks in advance.

Best Regards,

Naturel.

 

[appnair]

Do you not have a KB account? or access to the schema(it is free to a signed NDA)
Clues:A document whether it is PDF or DOC is still a subtype=144 in dtree, that way you can get all the dataid's that have 144 in a parentid
so select dataid from dtree where parentid=<folder's dataid> and subtype=144
with the dataid you need to look in dversdata this time it becomes the docid.dversdata has a filesize column
If you go to your livelink there is a bunch of canned live reports that OT bundles you can basicaly now repurpose the
queries

if you want to iterate subfolders/containers you can use dtreeancestors as that contains the relations that allow you to iterate over children.

Sorry for not posting full queries in a public forum.There are thousands of such queries already in the KB even this may have some as well.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in