Beispielsbericht: 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