Help > Views > V_StepsInteractive

View: V_StepsInteractive

Available in XBOUND 3.8 and later.

The view shows information about an executed interactive process step (ServiceType = 6). It includes all documents that have passed through an interactive step.

Column	Description
DocumentID	The ID of the document (ID in W_Step).
DocumentName	The name of the document (Name in W_Document).
Process	The name of the process (Name in C_Process).
Client	The name of the client (Name in C_Client).
UserName	The Windows user in whose name the process ran (UserName in W_Step).
RepCatName	The name of the reporting category.
StepID	The ID of the process step (ID in W_Step).
Action	Create Check out Check In Check in with Error Routed Manually Undo Check out Statistics (ActionType in W_Step)
CheckOutDuration	The period of time in seconds during which the document was checked out for this step. (CheckOutDuration in W_Step.)

SQL Script

CREATE VIEW [dbo].[V_StepsInteractive]
AS
SELECT  DocumentID, DocumentName, Process, Client, UserName, RepCatName, ID AS StepID, Action, CheckOutDuration
FROM   dbo.V_StepsReports
WHERE  (ActionType IN (2, 3, 5, 6)) AND (ServiceType = 6)

Uses

V_StepsReports

The available tables

The available views