Query database directly to get the number of fields that have been changed

Question / Problem: 

Is there a SQL query to get the number of fields that have been changed for exported batches?

Answer / Solution: 

 

FieldsFinished table contains all fields’ changes for batches that have been exported.

 

 

 

 

The query below brings the Batch Class name, Document type and Field name, the sum of fields and sum of changed fields.

 

 

The query also uses a date range, which needs to be modified to any given date range.

 

 

 

 

 

SQL:

 

 

SELECT BatchClassName, DocType, FieldName, SUM(__Result), SUM(Changed)

 

 

FROM FieldsFinished WHERE ReceivedTime >= '2018-AUG-25' AND ReceivedTime < '2018-DEC-30'

 

 

GROUP BY BatchClassName,  DocType, FieldName

 

 

ORDER BY 1,2,3;

 

 

 

 

 

ORACLE:

 

 

SELECT "BatchClassName","DocType","FieldName", SUM("_Result"), SUM("Changed")

 

 

FROM "FieldsFinished" WHERE  "ReceivedTime" >= TO_DATE('2018-AUG-25', 'YYYY-MON-DD') AND "ReceivedTime" < TO_DATE('2018-DEC-30', 'YYYY-MON-DD')

 

 

GROUP BY "BatchClassName",  "DocType", "FieldName"

 

 

ORDER BY 1,2,3;

 

 

 

The result is a list of fields for batches that have been Exported of Kofax Capture

Applies to:  

Product	Version
KAFC	2.0
KAFC	2.1