Publicado Thu, 15 Nov 2018 15:42:56 GMT por Nayeli Velázquez

 

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?

Publicado Thu, 15 Nov 2018 17:45:37 GMT por Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

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

You must be signed in to post in this forum.