V_QUERY_RESEARCHGROUP
Provides the ability to query research groups.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| DESCRIPTION | nvarchar(255) | Description | |
| OWNERID | uniqueidentifier | yes | Owner ID |
| OWNER_USERNAME | nvarchar(128) | yes | Owner username |
| OTHERSCANMODIFY | bit | Others can modify | |
| 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 |
| NUMMEMBERS | int | Number of members | |
| DATERETRIEVED | date | yes | |
| NUMRECORDS | int | ||
| ISREFRESHING | bit | ||
| LASTREFRESH | datetime | yes | |
| LASTRE7SYNC | datetime | yes | |
| POPULATEMETHOD | nvarchar(24) | yes | |
| AUTOREFRESH | bit | ||
| ALLOWREFRESH | bit | ||
| CATEGORYCODE | nvarchar(100) | yes | |
| OTHERSCANVIEW | bit | ||
| DATERETRIEVED2 | date | yes | |
| CATEGORYCODEID | uniqueidentifier | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:01:50 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RESEARCHGROUP AS
select
RG.ID,
RG.NAME,
RG.DESCRIPTION,
RG.OWNERID,
OWNER.USERNAME OWNER_USERNAME,
RG.OTHERSCANMODIFY,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
RG.DATEADDED,
RG.DATECHANGED,
RG.TSLONG,
RG.NUMMEMBERS,
dbo.UFN_RESEARCHGROUP_LASTWEALTHPOINTUPDATE(RG.ID) as DATERETRIEVED,
RG.NUMMEMBERS as NUMRECORDS,
RG.ISREFRESHING,
RG.LASTREFRESH,
RG.LASTRE7SYNC,
case when RG.ALLOWREFRESH = 1 then RG.POPULATEMETHOD else null end POPULATEMETHOD,
RG.AUTOREFRESH,
RG.ALLOWREFRESH,
RESEARCHGROUPCATEGORYCODE.DESCRIPTION as [CATEGORYCODE],
RG.OTHERSCANVIEW,
dbo.UFN_RESEARCHGROUP_LASTWEALTHPOINTUPDATE(RG.ID) as DATERETRIEVED2,
[RG].[CATEGORYCODEID]
/*#EXTENSION*/
from
dbo.RESEARCHGROUP RG
left join dbo.APPUSER as OWNER on OWNER.ID = RG.OWNERID
left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = RG.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = RG.CHANGEDBYID
left join dbo.RESEARCHGROUPCATEGORYCODE on RG.CATEGORYCODEID = RESEARCHGROUPCATEGORYCODE.ID