View: V_BacklogProcess
This view shows the total number of documents that are assigned to a
reporting category, per process step, regardless of whether they are in
the
or not – that is, regardless of IsEnd.
|
DocumentCount | Number (W_Token.ID).
|
ID | The ID of the process step (ID in C_ProcessStep). |
Name | The name of the process step (Name in
C_ProcessStep). |
ProcessID | The ID of the process (ID in C_Process).
|
Prozess | The name of the process (Name in C_Process).
|
Client | The name of the client (Name in C_Client).
|
IsEnd | The Production End Point setting.
0 = belongs to the . 1 = not part of the backlog. (IsEnd in C_ProcessStep) |
SQL Script
CREATE VIEW dbo.V_BacklogProcess
AS
SELECT COUNT(dbo.W_Token.ID) AS DocumentCount, dbo.V_ProcessStepWithCategory.ProcessStepID AS ID, dbo.V_ProcessStepWithCategory.ProcessStepName
AS Name,dbo.V_ProcessStepWithCategory.ProcessID, dbo.C_Process.NameAS Prozess, dbo.C_Client.Name AS Client, dbo.V_ProcessStepWithCategory.IsEnd
FROM dbo.V_ProcessStepWithCategory INNER JOIN
dbo.W_Token ON dbo.V_ProcessStepWithCategory.ProcessStepID = dbo.W_Token.ProcessStep.ID INNER JOIN
dbo.C_Client INNER JOIN
dbo.C_Process ON dbo.C_Client.ID = dbo.C_Process.ClientID ON dbo.V_ProcessStepWithCategory.ProcessID = dbo.C_Process.ID
WHERE (dbo.V_ProcessStepWithCategory.ReportingCat <> ' ')
GROUP BY dbo.V_ProcessStepWithCategory.ProcessStepName, dbo.V_ProcessStepWithCategory.ProcessID, dbo.V_ProcessStepWithCategory.ProcessStepID,
dbo.C_Process.Name, dbo.C_Client.Name, dbo.V_ProcessStepWithCategory.IsEnd, dbo.V_ProcessStepWithCategory.ReportingCat
Uses
Related topics
The available tables
The available views