V_QUERY_NEWSLETTER
Query view used for newsletters of constituent.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | yes | System record ID |
| NAME | nvarchar(184) | yes | Name |
| 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 |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:47:58 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_NEWSLETTER AS
select NCCU.CONSTITUENTID ID
,ET.NAME
--System Field
,ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION]
,ADDEDBY.USERNAME as [ADDEDBY_USERNAME]
,CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION]
,CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME]
,NCCU.DATEADDED
,NCCU.DATECHANGED
,NCCU.TSLONG
from dbo.EmailList_Subscription ES
INNER JOIN dbo.EmailList EL ON EL.ID=ES.EmailListID
INNER JOIN dbo.EmailTemplate_EmailList ETEL ON ETEL.EmailListID=EL.ID
inner join dbo.EmailTemplate ET ON ET.ID=ETEL.EmailTemplateID
INNER JOIN dbo.NETCOMMUNITYCLIENTUSER NCCU ON NCCU.BBNCUSERID=ES.UserID
LEFT JOIN dbo.CHANGEAGENT AS [ADDEDBY] on [ADDEDBY].ID = NCCU.ADDEDBYID
LEFT JOIN dbo.CHANGEAGENT AS [CHANGEDBY] on [CHANGEDBY].ID = NCCU.CHANGEDBYID