Help > Views > V_StepsVerificationTimeSum

View: V_StepsVerificationTimeSum

Available in XBOUND 3.8 and later.

This view shows the time per document needed for the Verification process steps.

Column

Description

DocumentID

The ID of the document (ID in W_Step).

Process

The name of the process (Name in C_Process).

Client

The name of the client (Name in C_Client).

VerificationTimeSum

The total number of seconds during which the document was checked out for a Verification process step.

UserName

The Windows user in whose name the process ran (UserName in W_Step).

SQL Script

CREATE VIEW [dbo].[V_StepsVerificationTimeSum]
AS
SELECT
   DocumentID, Process, Client, SUM(CheckOutDuration AS VerificationTimeSum, UserName
FROM      dbo.V_StepsVerification
GROUP BY  DocumentID, Process, Client, UserName

Uses

The available tables

The available views