Count Classified Items by Classification

Greg Kellogg

My client uses a complicated Classification Tree to Auto Classify documents.  We now need to know how many items have had specific classifications applied to them.  This should be a fairly simple query but I cannot seem to identify which Table/Column houses the Classification Name.

An example of our tree is"

Legal, Regulatory Compliance, and Enforcement Sub-buckets
   Regulatory Compliance and Enforcement
      Regulatory Compliance and Enforcement - Perm.

Since there are a lot of potential branches to the Classifcation Tree I would like to identify them by size.  In other words if I have RSIs for 3 years, 7 years and 25 years as well as Permanent records for Regulatory Compliance and Enforcement I need to be able to count each by RSI.

Again, I think the SQL will be simple if I can find out where in the DB to find Regulatory Compliance and Enforcement - Perm. (and any other RSI level).

Any help is greatly appreciated.

Greg Kellogg

Figured it out.  Names are stored in DTree.  I set up a four query process to walk the tree and create the counts from the llclassify table.

Greg Kellogg  | gkellogg@iqbginc.com  | P 361-758-3762 |  C 361-413-9200

the iQ Business Group

intelligence. applied.

www.IQBGinc.com

---

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Monday, February 27, 2017 10:32:08 AM
To: eLink Recipient
Subject: Count Classified Items by Classification

 

Count Classified Items by Classification

Posted by Kellogg, Greg On 02/27/2017 11:22 AM

My client uses a complicated Classification Tree to Auto Classify documents.  We now need to know how many items have had specific classifications applied to them.  This should be a fairly simple query but I cannot seem to identify which Table/Column houses the Classification Name.An example of our tree is"Legal, Regulatory Compliance, and Enforcement Sub-buckets    Regulatory Compliance and Enforcement       Regulatory Compliance and Enforcement - Perm.Since there are a lot of potential branches to the Classifcation Tree I would like to identify them by size.  In other words if I have RSIs for 3 years, 7 years and 25 years as well as Permanent records for Regulatory Compliance and Enforcement I need to be able to count each by RSI. Again, I think the SQL will be simple if I can find out where in the DB to find Regulatory Compliance and Enforcement - Perm. (and any other RSI level). Any help is greatly appreciated.

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

****** CONFIDENTIALITY NOTICE ****** This message and any attachments are confidential and for the sole use of the intended recipient. If you are not the intended recipient, any copying, forwarding, disclosure, distribution or use of any part of this message or its attachments is strictly prohibited and may be unlawful. If you believe that you received this email in error, please do not read it or any attachments thereto, and notify the sender immediately by email and then delete this message from your system. Thank you.