Help > Views > V_BacklogVolume

View: V_BacklogVolume

This view shows how many documents have a task, per client. This includes all process steps that are assigned to a reporting category, regardless of whether they are in the backlog or not – that is, regardless of IsEnd.

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

SQL Script

CREATE VIEW [dbo].[V_BacklogVolume]
AS
SELECT TOP (100) PERCENT SUM(DocumentCount) AS DocumentCount, Client
FROM  dbo.V_BacklogProcess
GROUP BY Client
ORDER BY DocumentCount DESC

Uses

V_BacklogProcess

The available tables

The available views