V_QUERY_CONSTITUENTSOCIALMEDIAACCOUNT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | ||
| SOCIALMEDIASERVICENAME | nvarchar(100) | ||
| USERID | nvarchar(100) | ||
| URL | UDT_WEBADDRESS | ||
| SOCIALMEDIAACCOUNTTYPECODEDESCRIPTION | nvarchar(100) | yes | |
| INFOSOURCECODEDESCRIPTION | nvarchar(100) | yes | |
| DONOTCONTACT | bit | ||
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| DATEADDED | datetime | ||
| DATECHANGED | datetime |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 4/26/2019 6:01:23 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2006.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CONSTITUENTSOCIALMEDIAACCOUNT AS
select
SOCIALMEDIAACCOUNT.ID,
SOCIALMEDIAACCOUNT.CONSTITUENTID,
SOCIALMEDIASERVICE.NAME SOCIALMEDIASERVICENAME,
SOCIALMEDIAACCOUNT.USERID,
SOCIALMEDIAACCOUNT.URL,
SOCIALMEDIAACCOUNTTYPECODE.DESCRIPTION SOCIALMEDIAACCOUNTTYPECODEDESCRIPTION,
INFOSOURCECODE.DESCRIPTION INFOSOURCECODEDESCRIPTION,
SOCIALMEDIAACCOUNT.DONOTCONTACT,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
SOCIALMEDIAACCOUNT.DATEADDED,
SOCIALMEDIAACCOUNT.DATECHANGED
/*#EXTENSION*/
from dbo.SOCIALMEDIAACCOUNT
inner join dbo.SOCIALMEDIASERVICE on SOCIALMEDIASERVICE.ID = SOCIALMEDIAACCOUNT.SOCIALMEDIASERVICEID
left join dbo.SOCIALMEDIAACCOUNTTYPECODE on SOCIALMEDIAACCOUNTTYPECODE.ID = SOCIALMEDIAACCOUNT.SOCIALMEDIAACCOUNTTYPECODEID
left join dbo.INFOSOURCECODE on INFOSOURCECODE.ID = SOCIALMEDIAACCOUNT.INFOSOURCECODEID
left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = SOCIALMEDIAACCOUNT.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = SOCIALMEDIAACCOUNT.CHANGEDBYID
where
WPMATCHCODE = '' or CONFIRMED = 1 --Only display if confirmed, or it was manually added by a user