USR_V_QUERY_BBWORKFLOWINSTANCETRACKING
Provides support for querying on Workflow Instance Tracking Record information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| EVENTTIME | datetimeoffset | Event time | |
| INSTANCEID | uniqueidentifier | Instance ID | |
| TRACELEVELCODE | tinyint | Trace level | |
| TRACKINGRECORDNUMBER | bigint | Tracking record number | |
| DATEADDED | datetime | Date added | |
| ADDEDBYID | uniqueidentifier | Added by | |
| ACTIVITYDEFINITIONID | nvarchar(510) | Activity definition ID | |
| WORKFLOWSTATE | nvarchar(100) | Workflow state | |
| REASON | nvarchar(1024) | Reason | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:20:16 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.USR_V_QUERY_BBWORKFLOWINSTANCETRACKING AS
select
BBWORKFLOWINSTANCETRACKING.ID,
BBWORKFLOWINSTANCETRACKING.[EVENTTIME],
BBWORKFLOWINSTANCETRACKING.[INSTANCEID],
BBWORKFLOWINSTANCETRACKING.[TRACELEVELCODE],
BBWORKFLOWINSTANCETRACKING.[TRACKINGRECORDNUMBER],
BBWORKFLOWINSTANCETRACKING.[DATEADDED],
BBWORKFLOWINSTANCETRACKING.[ADDEDBYID],
BBWORKFLOWINSTANCETRACKING.[ACTIVITYDEFINITIONID],
BBWORKFLOWINSTANCETRACKING.[WORKFLOWSTATE],
BBWORKFLOWINSTANCETRACKING.[REASON],
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME]
from
dbo.BBWORKFLOWINSTANCETRACKING
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = BBWORKFLOWINSTANCETRACKING.ADDEDBYID