Help > Views > V_StepsInteractiveTimeSum

View: V_StepsInteractiveTimeSum

Available in XBOUND 3.8 and later.

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

Column

Description

DocumentID

The ID of the document (ID in W_Step).

InteractiveTimeSum

The sum of the execution time of an interactive process step.

Process

The name of the process (Process in V_StepsReports).

Client

The name of the client (Client in V_StepsReports).

UserName

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

SQL Script

CREATE VIEW [dbo].[V_StepsInteractiveTimeSum]
AS
SELECT
   DocumentID, SUM(CheckOutDuration AS InterActiveTimeSum, Process, Client, UserName
FROM      dbo.V_StepsInteractive
GROUP BY  DocumentID, Process, Client, UserName

Uses

The available tables

The available views