Help > Views > V_BacklogClient

View: V_BacklogClient

This view summarizes the documents in the backlog by client. Process steps that are not part of the backlog (IsEnd = 1) are not included.

Column	Description
DocumentCount	The total number of documents in the backlog per client. (Sum of DocumentCount in V_BacklogProcess).
Client	The name of the client (Client in V_BacklogProcess).

SQL Script

CREATE VIEW [dbo].[V_BacklogClient]
AS
SELECT TOP (100) PERCENT SUM(DocumentCount) AS DocumentCount, Client
FROM  dbo.V_BacklogProcess
GROUP BY Client, IsEnd
HAVING (IsEnd <> 1)
ORDER BY DocumentCount DESC

Uses

V_BacklogProcess

The available tables

The available views