V_QUERY_SYSTEMROLETASK
List of tasks assigned to a system role.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| SYSTEMROLEID | uniqueidentifier | System role ID | |
| TASKID | uniqueidentifier | Task ID | |
| DISPLAYONHOMEPAGE | bit | Display on home page | |
| TASKNAME | nvarchar(100) | yes | Task name |
| TASKDESCRIPTION | nvarchar(max) | yes | Task description |
| TASKGROUP | nvarchar(100) | yes | Task group |
| TASKSEQUENCE | int | yes | Task sequence |
| FUNCTIONALAREANAME | nvarchar(100) | yes | Task functional area |
| 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 |
| TASKADDEDBY_APPLICATION | nvarchar(200) | yes | Task Added by application |
| TASKADDEDBY_USERNAME | nvarchar(128) | yes | Task Added by user name |
| TASKCHANGEDBY_APPLICATION | nvarchar(200) | yes | Task Changed by application |
| TASKCHANGEDBY_USERNAME | nvarchar(128) | yes | Task Changed by user name |
| TASKDATEADDED | datetime | yes | Task Date added |
| TASKDATECHANGED | datetime | yes | Task Date changed |
| TASKTSLONG | bigint | yes | Task Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:20:39 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SYSTEMROLETASK AS
select
SRT.ID,
SRT.SYSTEMROLEID,
SRT.TASKID,
SRT.DISPLAYONHOMEPAGE,
T.[NAME] AS TASKNAME,
T.[DESCRIPTION] AS TASKDESCRIPTION,
T.[TASKGROUP] AS TASKGROUP,
T.[SEQUENCE] AS TASKSEQUENCE,
FAC.[NAME] AS FUNCTIONALAREANAME,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
SRT.DATEADDED,
SRT.DATECHANGED,
SRT.TSLONG,
[TASKADDEDBY].APPLICATIONNAME as [TASKADDEDBY_APPLICATION],
[TASKADDEDBY].USERNAME as [TASKADDEDBY_USERNAME],
[TASKCHANGEDBY].APPLICATIONNAME as [TASKCHANGEDBY_APPLICATION],
[TASKCHANGEDBY].USERNAME as [TASKCHANGEDBY_USERNAME],
T.DATEADDED AS TASKDATEADDED,
T.DATECHANGED AS TASKDATECHANGED,
T.TSLONG AS TASKTSLONG
/*#EXTENSION*/
from dbo.SYSTEMROLETASK AS SRT
left join dbo.TASKCATALOG as T on SRT.TASKID=T.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = SRT.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = SRT.CHANGEDBYID
left join dbo.CHANGEAGENT as [TASKADDEDBY] on [TASKADDEDBY].ID = T.ADDEDBYID
left join dbo.CHANGEAGENT as [TASKCHANGEDBY] on [TASKCHANGEDBY].ID = T.CHANGEDBYID
left outer join dbo.FUNCTIONALAREACATALOG AS FAC
ON T.FUNCTIONALAREAID=FAC.ID