Total number of sheets -1542300176

How can I know the total number of sheets in a file cabinet? I know how I can see the total amount of documents, but in turn those documents have other documents with clips or staples. I want to know the total amount of sheets in a file cabinet. Can I make a query to the database?

You will need to use an SQL query to get the total number of pages in a document, particularly where you haver clipped documents together. Also, Fulltext must be active on the file cabinet as it provides this metric.

Versions up to DocuWare 6.12:
SELECT dwdocid, Sum(pagecount) as totalpages FROM YourTableName_sect group by dwdocid

DocuWare 7:
SELECT docid, Sum(totalpages) as totalpages FROM YourTableName_sec group by docid

Phil Robson
Senior Director Support Americas