I need to add the folder count to this live report

Will_Brantley

Hello, I want to modify this report to add the folder count to this report. The report is currently rendering the the number of documents, the size, the number of versions, and size.

 

WITH n(DataID, DataSize, SubType) AS
   (select DataID, DataSize, SubType from WebNodes where ParentID = %1
        UNION ALL
    SELECT nplus1.DataID, nplus1.DataSize, nplus1.SubType
    FROM WebNodes as nplus1, n
    Where n.DataID= nplus1.ParentID
)

select sum(NumDocs) as NumDocs,
       round(sum(DocSize)*1.0/1024.0/1024.0,2) as "DocSize (MB)",
       sum(NumVers) as NumVers,
       round(sum(VerSize)*1.0/1024.0/1024.0,2) as "VerSize (MB)"
from (
SELECT count(n.DataID) as NumDocs,
   sum(n.DataSize) as DocSize,
   0 as NumVers,
   0 as VerSize
FROM n
Where n.SubType = 144  
Union All
Select 0 as NumDoc, 0 as DocSize,
   Count(v.VersionID) as NumVers,
   Sum(v.DataSize) as VerSize
From n left join DVersData v on n.DataID = v.DocID
where n.SubType = 144
) tmp

Colin_Schmidt

Most of the script would change.  A folder won’t have size/bytes or version.  There’s be no accumulating.  It’d be much simpler.

 

Regards,

 

Colin J

 

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, December 18, 2017 7:48 PM
To: eLink Recipient
Subject: [EXT] I need to add the folder count to this live report

 

I need to add the folder count to this live report

Posted bywbrantley@cvrenergy.com (Brantley, Will) On 12/18/2017 07:45 PM

 

Hello, I want to modify this report to add the folder count to this report. The report is currently rendering the the number of documents, the size, the number of versions, and size.   WITH n(DataID, DataSize, SubType) AS    (select DataID, DataSize, SubType from WebNodes where ParentID = %1         UNION ALL     SELECT nplus1.DataID, nplus1.DataSize, nplus1.SubType     FROM WebNodes as nplus1, n     Where n.DataID= nplus1.ParentID ) select sum(NumDocs) as NumDocs,        round(sum(DocSize)*1.0/1024.0/1024.0,2) as "DocSize (MB)",        sum(NumVers) as NumVers,        round(sum(VerSize)*1.0/1024.0/1024.0,2) as "VerSize (MB)" from ( SELECT count(n.DataID) as NumDocs,    sum(n.DataSize) as DocSize,    0 as NumVers,    0 as VerSize FROM n Where n.SubType = 144   Union All Select 0 as NumDoc, 0 as DocSize,    Count(v.VersionID) as NumVers,    Sum(v.DataSize) as VerSize From n left join DVersData v on n.DataID = v.DocID where n.SubType = 144 ) tmp

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	My Support

 

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only.  Any unauthorized use, dissemination of the information, or copying of this message is prohibited.  If you are not the intended addressee, please notify the sender immediately and delete this message.