V_SEARCH_COMMUNICATIONLETTER
Search for communication letters.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| SEGMENTATION | nvarchar(100) | yes | |
| NAME | nvarchar(100) | ||
| CHANNEL | nvarchar(14) | yes | |
| MAILCONTENTDEFINED | int | ||
| EMAILCONTENTDEFINED | int |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:13:59 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_COMMUNICATIONLETTER AS
select
COMMUNICATIONLETTER.ID,
MKTSEGMENTATION.NAME as SEGMENTATION,
COMMUNICATIONLETTER.NAME,
COMMUNICATIONLETTER.CHANNEL,
case when len(MAILCONTENTHTML) > 0 then 1 else 0 end MAILCONTENTDEFINED,
case when len(EMAILCONTENTHTML) > 0 then 1 else 0 end EMAILCONTENTDEFINED
from dbo.COMMUNICATIONLETTER
left outer join dbo.MKTSEGMENTATION on COMMUNICATIONLETTER.SEGMENTATIONID = MKTSEGMENTATION.ID