Visning: V_EmptyPagesPerDocument
I denna visning kan du se antalet ark, sidor, bilder och tomma sidor per rotdokument.
|
DateOnly | Bearbetningsdatumet. |
ClientName | Namnet på klienten (Client i V_StepsReports). |
ClientID | ID för klienten (ID i C_Client). |
ProcessName | Namnet på processen. |
ProcessID | ID för processen (ID i C_Process). |
BatchID | ID för rotdokumentet (BatchID i V_StepsReports). |
SheetNo | Antalet ark i dokumentet. |
PageNo | Antalet sidor i dokumentet. |
PageEmpty | Antalet tomma sidor i dokumentet. |
ImageNo | Antalet bilder i dokumentet. |
SQL-skript
CREATE VIEW [dbo].[V_EmptyPagesPerDocument]
AS SELECT DISTINCT
dbo.V_StepsReports.DateOnly, dbo.C_Client. Name AS ClientName, dbo.C_Client.ID
AS ClientID, dbo.C_Process.Name AS ProcessName, dbo.C_Process.ID AS ProcessID, dbo.W_Document.BatchID,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Sheet
WHERE (BatchID = dbo.W_Document.BatchID)) AS SheetNo,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Page
WHERE (BatchID = dbo.W_Document.BatchID)) AS PageNo,
(SELECT COUNT(*) AS Expr1 FROM dbo.W_Page AS W_Page_1
WHERE (BatchID = dbo.W_Document.BatchID) AND (Empty = 1)) AS PageEmpty,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Image
WHERE (BatchID = dbo.W_Document.BatchID)) AS ImageNo
FROM dbo.C_Process INNER JOIN
dbo.C_Client ON dbo.C_Client.ID = dbo.C_Process.ClientID INNER JOIN
dbo.W_Document ON dbo.C_Process.ID = dbo.W_Document.ProcessID INNER JOIN
dbo.V_StepsReports ON dbo.W_Document.ID = dbo.V_StepsReports.DocumentID
Använder