View: V_BacklogOverallDetail
This view shows the total number of documents in the per reporting
category.
|
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 |
Name | The name of the reporting category (Name
in C_ReportingCat).
|
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.) |
SQL Script
CREATE VIEW [dbo].[V_BacklogOverallDetail]
AS
SELECT COUNT(dbo.W_Token_1.ID)
AS DocumentCount, dbo.V_ProcessStepWithCategory.IsEnd, dbo.V_ProcessStepWithCategory.ReportingCat AS Name,
(SELECT COUNT(ID) AS Expr1
FROM dbo.W_Token) AS OverallCount
FROM dbo.W_Token AS W_Token_1 INNER JOIN
dbo.V_ProcessStepWithCategory ON W_Token_1.ProcessStepID = dbo.V_ProcessStepWithCategory.ProcessStepID
WHERE (dbo.V_ProcessStepWithCategory.ReportingCat <> ' ')
GROUP BY dbo.V_ProcessStepWithCategory.IsEnd, dbo.V_ProcessStepWithCategory.ReportingCat
HAVING (dbo.V_ProcessStepWithCategory.IsEnd <> 1)
Uses
Related topics
The available tables
The available views