Does anyone have an example of a livereport that will list a count of documents within a parent folder and it's child folders? Any help would be greatly appreciated.
Regards,
Marlyn Norris
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
If you want just a could of documents, that's SELECT COUNT() from DTREE where ParentID = and SUBTYPE = 144 Change SUBTYPE = 144 to SUBTYPE = 0 to get folders. If you are looking to could all objects beneath a particular folder (i.e. children grandchildren etc), you need an inner join with DTreeAncestors i.e. select count() from DTree D inner join DTreeAncestors A on A.DataID=D.DataID where A.AncestorID =
YMMV -Hugh
PS in case anyone is cutting and pasting, that should be "SELECT COUNT(*)" in both queries above.
d.dataid in (select dataid from dtree connect by prior dataid=parentid start with Parentid="Parent folder ID") Use this function to display all sub folders and its contents
