CMC Imaging‎ > ‎Contact‎ > ‎Help‎ > ‎

Counting Documents and Pages in Docuware

posted May 24, 2017, 12:22 PM by Craig Williams   [ updated May 24, 2017, 12:23 PM ]
Need to know exactly how many documents and pages you have in a file cabinet?  There is not a direct way to do this but if you are the SQL administrator you can check with a simple query
if you are NOT a SQL admin you probably can not accomplish this but you can forward this to your SQL admin to assist them to getting the data you need.

SELECT 'LABEL' as 'File Cab', COUNT(*) AS 'Docs',  Coalesce(Sum(DWPAGECOUNT),0) as 'Pages'
  FROM {LOCATION OF YOUR FILE CABINET IN SQL}

Label is used to make the first column in the row the label for the data.

Count is exactly what you would expect keeps count of each line, 1 line 1 Document

Within the docuware data structure there is a PAGECOUNT item that tells how many pages are in the document.
Coalesce(Sum(DWPAGECOUNT),0) keeps a running total of the DWPAGECOUNT and reports the results.

So for example if you had a file cabinet named CLASSES if would look something like this:

  SELECT 'Classes' as 'File Cab', COUNT(*) AS 'Docs',  Coalesce(Sum(DWPAGECOUNT),0) as 'Pages'
  FROM [dwdata].[dbo].[classes]

This is assuming the location of the File cabinet table is dwdata.
IT will return a table like this:
File Cab Docs Pages
Classes 370         8664

Need more than 1 File cabinet UNION ALL works well
  SELECT 'Classes' as 'File Cab', COUNT(*) AS 'Docs',  Coalesce(Sum(DWPAGECOUNT),0) as 'Pages'
  FROM [dwdata].[dbo].[classes]
UNION ALL
  SELECT 'Testing' as 'File Cab', COUNT(*) AS 'Docs',  Coalesce(Sum(DWPAGECOUNT),0) as 'Pages'
  FROM [dwdata].[dbo].[TESTING]

File Cab Docs Pages
Classes 370         8664
Testing 406         4075

Pretty handy of you are trying to find out what you have quickly.
Comments