Generate list of files in folder and subfolder

Peter Stegl

I need to generate an list of files in an specific folder and it's subfolder. Afterwards it should be importet in Excel. Does anyone know how to do this? Just an manual to generate the Liverport could help also so far.LL 9.7.1Oracle 10.2Regards Peter

Appu_Nair

There are atleast a dozen or a couple of dozen livereports in this area for what you are looking for.Since it is Oracle what you need is a traversal by connect by a simple exampleselect dataid ,name,parentid from dtree where subtype=144 connect by prior dataid=parentid start with dataid=%1Here replace %1 with a hardcoded nodeid that you know has documents in it.See how to handle negative dataid's by reading this forum.as far as getting it into excel if you do not have webreports this thread may helphttp://www.tek-tips.com/viewthread.cfm?qid=1411407This relies on excle ability to call a web page lot of manual things after that