V_SEARCH_MKTLETTERCODE
Search screen for finding letter records.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| MAILINGTYPE | varchar(25) | ||
| WORDTEMPLATEFILENAME | nvarchar(255) | ||
| EXPORTDEFINITION | nvarchar(200) | yes | |
| STATUS | varchar(8) | ||
| INCLUDESRECEIPT | varchar(3) | ||
| DESCRIPTION | nvarchar(255) | ||
| SITES | nvarchar(max) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:54:25 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_MKTLETTERCODE AS
select
[LETTERCODE].[ID],
[LETTERCODE].[NAME],
case dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMRECORDTYPEID]([EXPORTDEFINITION].[RECORDTYPEID])
when 0 then 'Direct marketing'
when 1 then 'Marketing acknowledgement'
when 2 then 'Membership'
when 3 then 'Sponsorship'
else '' end as [MAILINGTYPE],
[LETTERCODE].[WORDTEMPLATEFILENAME],
[EXPORTDEFINITION].[NAME] as [EXPORTDEFINITION],
(case when [LETTERCODE].[ISACTIVE] = 1 then 'Active' else 'Inactive' end) as [STATUS],
(case when [LETTERCODE].[INCLUDESRECEIPT] = 1 then 'Yes' else 'No' end) as [INCLUDESRECEIPT],
[LETTERCODE].[DESCRIPTION],
(isnull((select dbo.[UDA_BUILDLIST]([SITE].[NAME]) from dbo.[SITE] with (nolock) left join dbo.[LETTERCODESITE] with (nolock) ON [LETTERCODESITE].[LETTERCODEID] = [LETTERCODE].[ID]
where [LETTERCODESITE].[SITEID] = [SITE].[ID]), '')) as [SITES]
from dbo.[LETTERCODE]
left join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]