RE Report for finding all folders that contain 200 or more documents... Posted by rpike (Pike, Ric) on 09/26/2005 03:09 AM In reply to: Report for finding all folders that contain 200 or more documents... Posted by IDELAB01Admin (Black, Sue) on 09/23/2005 11:04 AM Message from Pike, Ric (EXP N-SPAN) <ric.pike@lmco.com> via eLinkI did something similar (but for folders with >25 docs). It was my first LiveReport but seems to do the job.... select dataid,name from dtree where dataid in (select parentid from dtree where subtype=144 group by parentid having count(*)>25) -----Original Message----- From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 23 September 2005 16:48 To: eLink Recipient Subject: Report for finding all folders that contain 200 or more documents... Report for finding all folders that contain 200 or more documents... Posted by Black, Sue on 09/23/2005 11:04 AM I have been struggling with this SQL for a while now and cannot figure out how to get a list of all folders with 200 or more documents. Is anybody doing something similar? Any direction on this would be helpful. Thanks! [To reply to this thread, use your normal E-mail reply function.] ============================================================ Discussion: Livelink LiveReports Discussion https://knowledge.opentext.com/knowledge/livelink.exe/open/2249677 Livelink Server: https://knowledge.opentext.com/knowledge/livelink.exe To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.
