New documents ordered by folder

Birger_Jacobsen_(danskadmin_-_(deleted))

Can anybody help me making a report viewing the latest docsordred by folder. I know it could be like this :select * from dtree where (createdate>%1) and %2 order by createdate desc%1 last week-end%2 Filter permissionsThis show me all docs but not the folder where its belongAny idea will be helpfull

eLink User

Message from Sean M Alderman via eLinkI think you need to join dtree twice. Once for the document at hand,and a second time for it's parentID. Something like -select a.name, b.* from dtree a, dtree b where (b.createdate > %1) and%2 and a.id = b.parentid order by b.createdate, b.descOn Wed, 2002-01-30 at 08:59, eLink Discussion: Livelink LiveReportsDiscussion wrote:> New documents ordered by folder> Posted by DanskAdmin on 01/30/2002 08:59 AM> > Can anybody help me making a report viewing the latest docs> ordred by folder. I know it could be like this :> > select * from dtree where (createdate>%1) and %2 order by createdate desc> %1 last week-end> %2 Filter permissions> > This show me all docs but not the folder where its belong> > Any idea will be helpfull> > [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=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."