View: V_BacklogOverall

This view shows the total number of documents in the backlog for all clients. It also outputs the total number of documents (for all clients) with a task (IsEnd >=0).

CREATE VIEW dbo.V_BacklogOverall
AS
SELECT COUNT(W_Token_1.ID) AS DocumentCount, dbo.V_ProcessStepWithCategory.IsEnd,
           (SELECT COUNT(ID) AS Expr1
            FROM dbo.W_Token) AS OverallCount
FROM dbo.W_Token AS W_Token_1 INNER JOIN
        dbo.C_ProcessStepWithCategory ON W_Token_1.ProcessStepID=dbo.V_ProcessStepWithCategory.ProcessStepID
WHERE (dbo.V_ProcessStepWithCategory.ReportingCat <> ' ')
GROUP BY dbo.V_ProcessStepWithCategory.IsEnd
HAVING (dbo.V_ProcessStepWithCategory.IsEnd<>1)

Column	Description
DocumentCount	The total number of documents that are still in the backlog. (Number of IDs in W_Token where IsEnd=0.) A subset of OverallCount.
IsEnd	0 = belongs to the backlog
OverallCount	The total number of documents that still have a task, regardless of whether they are in the backlog or not – that is, regardless of IsEnd. (Number of IDs in W_Token.)

View: V_BacklogOverall

SQL Script

Uses