V_QUERY_BBWORKFLOWTASK
Provides support for querying on Workflow Task information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| BBWORKFLOWINSTANCEINFOID | uniqueidentifier | BBWORKFLOWINSTANCEINFOID | |
| BBWORKFLOWINBOXID | uniqueidentifier | Workflow inbox | |
| TASKSUBJECT | nvarchar(255) | Task subject | |
| TASKDESCRIPTION | nvarchar(max) | Task description | |
| TASKSTATUS | nvarchar(9) | yes | Status |
| DATEASSIGNED | datetimeoffset | Date assigned | |
| DATEDUE | datetimeoffset | yes | Date due |
| DATECOMPLETED | datetimeoffset | yes | Date completed |
| CATEGORY | nvarchar(50) | Category | |
| LOOKUPID | nvarchar(100) | yes | Lookup ID |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| OWNER_APPUSERID | uniqueidentifier | yes | |
| OWNER_APPUSERNAME | nvarchar(255) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:14:04 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BBWORKFLOWTASK AS
select
BBWORKFLOWTASK.ID,
BBWORKFLOWTASK.[BBWORKFLOWINSTANCEINFOID],
BBWORKFLOWTASK.[BBWORKFLOWINBOXID],
BBWORKFLOWTASK.[TASKSUBJECT],
BBWORKFLOWTASK.[TASKDESCRIPTION],
BBWORKFLOWTASK.[TASKSTATUS],
BBWORKFLOWTASK.[DATEASSIGNED],
BBWORKFLOWTASK.[DATEDUE],
BBWORKFLOWTASK.[DATECOMPLETED],
BBWORKFLOWTASK.[CATEGORY],
BBWORKFLOWTASK.[LOOKUPID],
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
BBWORKFLOWTASK.DATEADDED,
BBWORKFLOWTASK.DATECHANGED,
BBWORKFLOWTASK.TSLONG,
BBWORKFLOWTASK.OWNER_APPUSERID,
coalesce(nullif(AU.DISPLAYNAME, ''), nullif(AU.USERNAME, ''), '') AS OWNER_APPUSERNAME
from
dbo.BBWORKFLOWTASK
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = BBWORKFLOWTASK.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = BBWORKFLOWTASK.CHANGEDBYID
left join dbo.APPUSER as AU on AU.ID=BBWORKFLOWTASK.OWNER_APPUSERID