V_QUERY_BBWORKFLOWINSTANCEINFO
Provides support for querying on Workflow Instance Info information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| INITIATEDBY_APPUSERID | uniqueidentifier | Started by AppUser ID | |
| WORKFLOWSTARTDATE | datetimeoffset | Workflow start date | |
| BBWORKFLOWCATALOGID | uniqueidentifier | WorkflowSpec Catalog ID | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| DATEADDED | datetime | Date added | |
| LOOKUPID | nvarchar(100) | yes | |
| STARTSTATUS | nvarchar(7) | yes | |
| COMPLETIONSTATE | nvarchar(8) | yes | |
| WORKFLOWENDDATE | datetimeoffset | yes | |
| ISRUNNING | bit | yes | |
| CANCEL_OR_FAULT_REASON | nvarchar(max) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:08:37 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BBWORKFLOWINSTANCEINFO AS
select
BBWORKFLOWINSTANCEINFO.ID,
BBWORKFLOWINSTANCEINFO.[INITIATEDBY_APPUSERID],
BBWORKFLOWINSTANCEINFO.[WORKFLOWSTARTDATE],
BBWORKFLOWINSTANCEINFO.[BBWORKFLOWCATALOGID],
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
BBWORKFLOWINSTANCEINFO.DATEADDED,
BBWORKFLOWINSTANCEINFO.[LOOKUPID],
BBWORKFLOWINSTANCEINFO.[STARTSTATUS],
BBWORKFLOWINSTANCEINFO.[COMPLETIONSTATE],
BBWORKFLOWINSTANCEINFO.[WORKFLOWENDDATE],
BBWORKFLOWINSTANCEINFO.[ISRUNNING],
BBWORKFLOWINSTANCEINFO.[CANCEL_OR_FAULT_REASON]
from
dbo.BBWORKFLOWINSTANCEINFO
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = BBWORKFLOWINSTANCEINFO.ADDEDBYID