Report for Folders with Zero Items

Nancy_Lyons_(boozuser3_-_(deleted))

I am looking for a Report that tells the user all the folders in a Project with Zero items in them?Thanks - Mitch

eLink User

Message from Alex Kowalenko via eLinkDTree.ChildCount gives you the number of items in a container. A query to dowhat you need would be something like this:select Name from DTree where ChildCount = 0 and /* no items */ OwnerID = and /* project id number */ SubType = 0 /* folder */ order by Name /* sort it by folder name */You can use %1 (Report Fields) in place of Name in a LiveReport to get alist of folders in the LiveReport format.-alex------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, September 12, 2002 11:52To: eLink RecipientSubject: Report for Folders with Zero ItemsReport for Folders with Zero ItemsPosted by BoozUser3 on 09/12/2002 11:39 AMI am looking for a Report that tells the user all the folders in a Projectwith Zero items in them?Thanks - Mitch[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe