SQL query to report on active ABBYY FlexiCapture batches by status and document count

Created by Jeremy Burgess, Modified on Tue, 10 Jun at 11:58 AM by Jeremy Burgess

Symptoms

You want to report on the document processing batches within ABBYY FlexiCapture.

Cause

n/a

Resolution

Use the following SQL query to generate a simple report.

SELECT  Project.Name as Project
        , BatchType.Name as BatchType
        , ProcessingStage.Name AS Stage
        , Batch.Name AS BatchName
        , Batch.PagesCount
        , Batch.DocumentsCount
        , Batch.ExportedDocumentsCount
        , Batch.CreationDate
        , Batch.Status
    FROM Batch
    INNER JOIN BatchType
        ON Batch.BatchTypeId = BatchType.Id
    INNER JOIN Project
        ON Batch.ProjectId = Project.Id
    LEFT OUTER JOIN ProcessingStage
        ON Batch.ProcessingStageId = ProcessingStage.Id
    WHERE 1 = 1
        AND Batch.BatchPurpose = 0 -- 0 = batch with data, 1 = batch for training Document Definition matching, 2 = batch for training classifiers
        --AND (Batch.DocumentsCount - Batch.ExportedDocumentsCount) <> 0 -- This excludes 'empty' (export complete) batches
        --AND Batch.IsDeleted = 0 -- Excludes batches marked as deleted
        --AND Status <> 0
ORDER BY Project.Name, BatchType.Name, Stage, BatchName