Empty folders in Enterprise workspace

HiI have a report which produces for me a list of all the empty folders in our Livelink system. This is produced using the following SQLselect dataid, name, createdate from DTree where ChildCount = 0 and SubType = 0 order by createdateThis returns empty folders that are in the enterprise workspace and users personal workspaces.I would however like (if possible) to restrict the results of this report so that only empty folders in the enterprise workspace are returned and personal workspaces are ignored.I did try adding Filter enterpise workspace to one of the parameters but this had no effect.It would also be nice (but not so important) to have a seperate report showing empty folders in personal workspaces and which woprkspaces they are in. ThanksDavid

Find more posts tagged with

Comments

John W. Simon, Jr.

I can get you a little closer...but not quite there.select a.ownerid, a.dataid, a.name, b.subtypefrom dtree a, dtree bwhere abs(a.ownerid) = b.dataidand a.subtype = 0and a.childcount = 0subtype = 141 --> Enterprise WSsubtype = 142 --> Personal WSsubtype = 202 --> Projectsubtype = 3030 --> Recycle BinThe problem is the Projects...are they in the Enterprise WS or Personal WS? You would have to put some kind of connectby (Oracle) to keep "walking" up the tree...

Hans Stoop

Message from Hans Stoop via eLinkI don't know if you have projects or not, but if you don't use projects,then add 'ownerid = -2000' to the query.Hans > -----Original Message-----> From: eLink Discussion: Livelink LiveReports Discussion > [mailto:livereportsdiscussion@elinkkc.opentext.com] > Sent: woensdag 18 april 2007 11:50> To: eLink Recipient> Subject: Empty folders in Enterprise workspace> > Empty folders in Enterprise workspace> Posted by Turpie, David on 04/18/2007 05:30 AM> > Hi> > I have a report which produces for me a list of all the empty > folders in our Livelink system. This is produced using the > following SQL> > select dataid, name, createdate from DTree where ChildCount = > 0 and SubType = 0 order by createdate> > This returns empty folders that are in the enterprise > workspace and users personal workspaces.> > I would however like (if possible) to restrict the results of > this report so that only empty folders in the enterprise > workspace are returned and personal workspaces are ignored.> > I did try adding Filter enterpise workspace to one of the > parameters but this had no effect.> > It would also be nice (but not so important) to have a > seperate report showing empty folders in personal workspaces > and which woprkspaces they are in.> > Thanks> > David> > [To reply to this thread, use your normal E-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677> > Livelink Server:> https://knowledge.opentext.com/knowledge/llisapi.dll> > To Unsubscribe from this Discussion, send an e-mail to > unsubscribe.livereportsdiscussion@elinkkc.opentext.com.> > >

Lindsay_Davies

Message from Lindsay Davies via eLinkHi David,You can be more specific about workspaces if you like.Your original SQL does nothing to limit workspaces.As John implies, Projects have their own workspaces.Therefore you may want to exclude them from the Enterprise based query.There is information in the DTree row that tells you what the workspaceis.This is the OwnerID column.For example... select DataID, Name, ParentID from DTree where SubType=0 andChildCount=0 and OwnerID=-2000would show you which folders in the Enterprise workspace are empty.RegardsLindsay

David_Turpie

Thanks to all for your helpI now appear to have a report I can work withSimple when you know David