Exempelrapport: Detailed Capture Statistics

SELECT Client, Process, ReclassifiedDocName, Name,

(SELECT COUNT(DISTINCT DocID) AS Expr1

FROM V_StepsDocReport AS Sel1

WHERE (ProcessID = V_FieldsStepsReport.ProcessID)

AND (V_FieldStepsReport.ReclassifiedTypeID = ReclassifiedTypeID)

AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS DocCount,

(SELECT COUNT(DISTINCT FieldID) AS Expr1

FROM V_FieldPerDocument AS Sel1

WHERE (ProcessID = V_FieldsStepsReport.ProcessID) AND (Name = V_FieldStepsReport.Name)

AND FieldEvaluation < 4) AND (V_FieldStepsReport.ReclassifiedTypeID = ReclassifiedTypeID)

AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS FieldCount,

(SELECT COUNT(FieldEvaluation) AS Expr1

FROM V_FieldPerDocument AS Sel1

WHERE (ProcessID = V_FieldStepsReport.ProcessID)

AND (V_FieldStepsReport.ReclassifiedTypeID = ReclassifiedTypeID)

AND (Name = V_FieldStepsReport.Name) AND (FieldEvaluation = 0) AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS FieldCorrect,

(SELECT COUNT(FieldEvaluation) AS EXPR1

FROM V_FieldPerDocument AS Sel1

WHERE (ProcessID = V_FieldStepsReport.ProcessID)

AND (ReclassifiedTypeID = V_FieldStepsReport.ReclassifiedTypeID) AND

(Name = V_FieldStepsReport.Name) AND (FieldEvaluation = 2) AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS FieldSuggCorr,

(SELECT COUNT(FieldEvaluation) AS Expr1

FROM V_FieldPerDocument AS Sel1

WHERE (ProcessID = V_FieldStepsReport.ProcessID)

AND (ReclassifiedTypeID = V_FieldStepsReport.ReclassifiedTypeID) AND

(Name = V_FieldStepsReport.Name) AND (FieldEvaluation = 3) AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS FieldSuggWrong,

(SELECT COUNT(FieldEvaluation) AS Expr1

FROM V_FieldPerDocument AS Sel1

WHERE (ProcessID = V_FieldStepsReport.ProcessID)

AND (ReclassifiedTypeID = V_FieldStepsReport.ReclassifiedTypeID) AND

(Name = V_FieldStepsReport.Name) AND (FieldEvaluation = 1)AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)) AS FieldSubstituted

FROM V_FieldStepsReport

WHERE (Client IN (@strClient)) AND (Process IN (@strProcess)) AND ((CASE WHEN ParentID = 0 THEN (CASE WHEN ReclassifiedDocName IS NULL

THEN '<not assigned>'

WHEN ReclassifiedDocName = '<only sub-document types>'

THEN ' ' ELSE ReclassifiedDocName END) END) IN (@RootDocumentType) OR

(CASE WHEN ParentID <> 0 THEN (CASE WHEN ReclassifiedDocName IS NULL

THEN '<not assigned>' WHEN ReclassifiedDocName = '<only sub-document types>' THEN ' ' ELSE ReclassifiedDocName END)

END) IN (@SubDocumentType)) AND (VerifyDateOnly BETWEEN @StartDate AND @EndDate)

GROUP BY Client, ProcessID, Process, ReclassifiedTypeID, ReclassifiedDocName, Name