Finding empty folders

Is there a suggested best way to find all empty folders under a parent folder? We want to be able to provide the client areas with a list of empty folders that may be deleted.

We are using a SQl database.

thanks for any pointers!

Donna

Find more posts tagged with

Comments

Colin_Schmidt

Easy. There's a dtree.childcount that will tell you if a Folder(dtree.subtype = 0) is empty or not.

Colin

On Tue, Sep 3, 2013 at 9:03 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Finding empty folders Posted bypelletd1@rjrt.com (Pellett, Donna)On 09-03-2013 08:55

Is there a suggested best way to find all empty folders under a parent folder? We want to be able to provide the client areas with a list of empty folders that may be deleted. We are using a SQl database. thanks for any pointers! Donna
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Donna_Pellett

Thank you for the quick response!
I was looking at that column on the table wondering if it would be the correct way to go. Thank you for confirming that for us.

I appreciate this forum and the help we are able to get using it!

Greg_Griffiths

I'd run a DB Verification as well prior to the Query as sometimes the ChildCount column does not get updated correctly, so you may find you have some things that report as having no children when they do and vice versa, not a regular problem, but may impact your results.

For a different view, I'd look at DTREEANCESTORS and get a list of all nodes that are descendants of your dataif and then join it to DTREE to allow you to filter on the SUBTYPE column to return only Folders, then for each of those, either in a single query using a temp table for example or individual queries, do something like SELECT COUNT(*) FROM dtree WHERE parentid = <the id>.