Report On Folder and all its contents

Nancy_Lyons_(boozuser3_-_(deleted))

I have been working on a report to find all the sub folders and sub items of a particular folder or project. I never seem to be able to do it. I get the sub items of the folder, but if there is anther folder in that particular folder, I cannot retrieve the information on those sub items. Can some one tell me, what I may be doing wrong and hopefully I have not confused anyone.ThanksMitch

eLink User

Message from Bax Ruud, F.C. via eLinkIf you're using Oracle you could try the followingselect * from dtree start with dataid = connect byprior dataid = parentidRegards,Ruud> -----Oorspronkelijk bericht-----> Van: eLink Discussion: Livelink LiveReports Discussion> [SMTP:livereportsdiscussion@elinkkc.opentext.com]> Verzonden: woensdag 30 oktober 2002 22:27> Aan: eLink Recipient> Onderwerp: Report On Folder and all its contents> > Report On Folder and all its contents> Posted by BoozUser3 on 10/30/2002 04:18 PM> > I have been working on a report to find all the sub folders and sub items> of a particular folder or project. I never seem to be able to do it. I> get the sub items of the folder, but if there is anther folder in that> particular folder, I cannot retrieve the information on those sub items.> Can some one tell me, what I may be doing wrong and hopefully I have not> confused anyone.> > Thanks> Mitch> > > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=224967> 7&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > ****************************************************************************This e-mail and any files transmitted with it are confidential and intendedsolely for the use of the individual or entity to whom they are addressed.If you have received this e-mail in error, please notifypostmaster@oranjewoud.nlThis footnote also confirms that this e-mail message has been checked byMcAfee Groupshield for the presence of computer viruses.****************************************************************************